Calculating Static Dates

I have a dataset of weekly days which should trigger a backend Workflow at that time.
Monday, 8AM
Tuesday, 9AM
Wednesday, 10AM

Lets assume we have Friday and i want to schedule the workflow on Monday, 8AM. How should i proceed to calculate the time difference between the current and the schedule time?

Hey @tbaohoang94 :wave:

Here are some examples you can do with the current time. You can simply round down to week to go the beginning of a week and then it is upto you where to go next:
image

And here is the output:
image

If you want to check the editor yourself: Bubble Demos by Flusk | Bubble Editor

bdk_512x512 @Huseyin from Flusk | Discover the #1 Security and Monitoring Tool for Bubble

Thanks for your reply @flusk . Im still a bit clueless how im able to schedule the exact weekday and time. I mean i have to calculate the day and hour difference first to get the “+days” and “+hours”. When i round the current date down to a week its sunday 12AM so now i have to calculate the time difference to lets say monday 8AM.

How can i do that?

You dont need to calculate time difference. Once you round down to week (which is sunday 12am), you add one day (which makes it monday 12am) and add 8 hours (which is monday 8am).

bdk_512x512 @Huseyin from Flusk | Discover the #1 Security and Monitoring Tool for Bubble

I know but you mean. When im calculating it in my head i can tell the time difference. But what i like to do is do that dynamically depend to the data of my list.

This formula will give you the monday 8am of that week, no matter what the date is.

bdk_512x512 @Huseyin from Flusk | Discover the #1 Security and Monitoring Tool for Bubble