How to find the data of next Monday

I just did this for two separate apps. It’s not the most convenient, but you can do it.

It’s all in extracting the day of the week. Bubble has Sunday as 0, Monday as 1, etc.

You take current date + 7 days (to get you to next week) and then subtract the difference between today’s day of the week and 1 (Monday).

So if today is Monday:

Current Date +(days) 7 +(days) 0 = next Monday’s date

If today is Tuesday:

Current Date +(days) 7 +(days) -1 = next Monday’s date

etc.

To calculate the difference you can do “Current Date/Time :extract day - 1”

Monday would be 1-1 = 0
Tuesday would be 2-1 = 1
Wed is 3-1 = 2

etc.

Yes, it’s annoying, but you can do it. I’d be into an API that does this for you too…

3 Likes