Help with Setting Week Start on Sunday

aalok.sah · 2024-08-26T12:03:08.343Z

I’m building a time tracking app, and in my country, the week starts on Sunday and ends on Saturday. I need to adjust my app in Bubble so that the current week starts on Sunday instead of Monday.

Specifically, I want the values in my table to reset on Sunday, showing “00” values at the start of the new week.

image1136×346 24.5 KB

I am using this expression to filter out dates

image974×511 29 KB

Is there any way for that, please help

Zeroic · 2024-08-26T13:25:29.345Z

Using the :extract day operator in Bubble would anyhow return 0 for Sunday. Any issue with this, or am I missing something here?

manual.bubble.io

Operators and comparisons | Bubble Docs

Aggregating, manipulating and comparing data.

aalok.sah · 2024-08-26T13:47:14.553Z

Hi Zeroic,

In my country, the first day of the week is Sunday. However, I’m facing an issue in Bubble.io where the week seems to start on Monday instead.

Here are the details from Bubble:

On Sunday:

Screenshot 2024-08-25 192529

On Monday

Screenshot 2024-08-26 192508700×204 11.2 KB

As you can see, on Sunday, the week number is 34, but on the next day (Monday), it changes to 35. This indicates that Bubble is currently considering Monday as the start of the week.

What I want is for Sunday to be the start of the week, so Sunday would be “Week 35, Day 0” and Monday would be “Week 35, Day 01.”

Any advice on how to achieve this?

system · 2024-11-04T12:04:02.236Z

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