Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Different week numbers for the same date

Topic Labels: Dates & Timezones
242 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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