Help

Get correct week number and date

Topic Labels: Dates & Timezones
594 1
cancel
Showing results for 
Search instead for 
Did you mean: 
VladimirKrstic
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I need assistance with getting the proper year in an ISO week start date so that I can get a valid week start date. I have the following formula:

 

DATETIME_PARSE(DATETIME_FORMAT({Date Field}, "W"), "W")

 

Month and day outputs from this method are accurate, but a year is not. It is stuck in 2023, the current year. Can somebody assist me? It's acceptable if I need to use more than one field to accomplish this, for example, one field to obtain the proper year and one field to obtain the correct day.

Sincerely appreciated!

 

1 Reply 1

Hm, could you provide a screenshot of your table with the relevant fields as well as an example or two of a date and the output you would want?