I’m having trouble getting DATETIME_FORMAT to work, and I can’t figure out what I’m missing.
My date field is in local time. I wanted to get week numbers from the date, which I have working fine, but it is seeing dates in UTC I think, and DATETIME_FORMAT did not work.
Referencing the red box you can see two entries with incorrect format. I’m a little stumped.