Format "current date/time" to (always) 12:00 am

Hi all,

I’m using a calendar (stored in the database).
All “DAYs” are stored in the format:

image

As you can see, all dates are stored in the “12:00 am”-Format.
Now I want to initialize the current date/time in my app and I get the (“real”) current date/time. E.g: 11/19/24 8:13 pm.
I want to set this value now to 12:00 am to get a match in my database (11/19/24 12:00 am).

Any idea to achieve this?

Many thanks,
jupxi

If you store the Current date/time you will get the 11/19/24 8:13 pm
If you store the Current date/time:rounded down to date you will get 11/19/24 12:00 am

Bubble stores the exact unix timestamp, what you are seeing is just a friendly format they have in the database tab. You can still take any date and do :format as and customize it

1 Like