Different week numbers for the same date

Topic Labels: Dates & Timezones
614 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

The start day of our week is Sunday and closes on Saturday. However, when I tried using the datetime format it has a different week number compared to ISO week. I have different week numbers for the same date when I used the datetime format for the local and iso format. For example, if I have the date Apr 6, 2022:

DATETIME_FORMAT(Date, "W") // result would be 14
DATETIME_FORMAT(Date, "w") // result would be 15

We want to have 14 as the result of the week number but the first formula starts with Monday instead of Sunday. Is there any way how to do it?

0 Replies 0