Extract Week Starts on Monday?

QIRO · 2024-10-14T21:14:55.943Z

When I extract a week number from a date it seems to be starting the week from Monday, not Sunday.

I know the question on this forum is usually how to adjust the week start forward to Monday, but in this case I want it to be Sunday and I’ve no idea why I’m seeing this behavoir.

Any ideas?

For clarity, Week 42 started on 13/10/2024 for the purposes of this application.

adamhholmes · 2024-10-14T21:37:56.865Z

As per the ISO-8601 standards, the Week starts on Monday.

What's the Current Week Number?.

Week 42 is from Monday, October 14, 2024 until (and including) Sunday, October 20, 2024.

But if you want your app to include Sunday from the Previous week as part of the next week you can just add 1 to the extracted Week if the day is a Sunday (although that may confuse people, as it’s actually incorrect).

QIRO · 2024-10-14T21:59:06.709Z

I am very much from the part of the world that aligns to this standard, however the American firm we work with…does not.

Hey ho.

The conditional is a good idea, I’ll give that a go, thank you.

mghatiya · 2024-10-15T07:39:35.447Z

adamhholmes:

As per the ISO-8601 standards, the Week starts on Monday.

Interesting. Then why does Bubble return 0 for Sunday and 1 for Monday and so on when we ‘extract day’ from a date?

adamhholmes · 2024-10-15T08:37:35.089Z

Because in Bubble.io, as in JavaScript, and many other programming languages (although not all), a Week starts on Sunday:

Sunday = 0
Monday = 1
Tuesday = 2
Wednesday = 3
Thursday = 4
Friday = 5
Saturday = 6

But the ISO 8601 standard doesn’t care about JavaScript (or any other specific language).

In vanilla Javascript there is no built in way to establish the Week from a given Date, but libraries like Luxon.js or (the outdated/deprecated) moment.js (which is what Bubble still uses for Dates) have built in methods for getting the week of given Date, which follow the ISO standard of Weeks (at least in the context of establishing the week number) starting on Monday.

Confusing? yep… (dates/timezones really are…)

mghatiya · 2024-10-16T02:59:25.884Z

Thanks @adamhholmes for detailed explanation.

system · 2024-12-23T21:15:39.125Z

This topic was automatically closed after 70 days. New replies are no longer allowed.