Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Get correct week number and date

Topic Labels: Dates & Timezones
1019 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?