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?