"Only When" option in update an item workflow option don't allow dates "less than or equal to"

Need help
1

Hi there,

I need to update an item in a backend workflow but only when a date in my database is “less than or equal to” the current date/time. I also need the option to update it when the same date is “greater than or equal to” the current date/time. I just need this rounded down to the day. Not the second. But the option is not offered. The date in my database is a user-entered date. They don’t enter “seconds” at all anyway. I have used ChatGPT and Gemini and both recommend solutions that are not possible. Any ideas?

3

@jasongood89 Yes, this is possible. The trick is to compare dates at day level, not full date-time.

In Bubble, use :rounded down to day on both values before comparing.
Example condition in your backend workflow:

Thing's date:rounded down to day ≤ Current date/time:rounded down to day

And for the opposite case:

Thing's date:rounded down to day ≥ Current date/time:rounded down to day

That removes the seconds and time portion, so the comparison works purely by day.