Just to add on to @yusaney1’s response, which is accurate, I think knowing a bit more about the format of the date/time type will help.
Bubble saves date values as UNIX, which is inherently a value that indicates a date and time.
This makes a date value in the database zoneless. By default, Bubble will display date values according to your local timezone. If you look at dates in your App data then change your computer’s zone, you’ll see the change.
So, it’s up to you to display the date value:
- For local zone (default) or a specific zone (with :formatted as)
- As an extracted date or time only if that’s what you want (with :formatted as)
Yes, as soon as you format a date, you strip it of its date and time properties, so do whatever date math if needed before you format to a custom text display.
If your use case for the date value is the date part only, it’s ok that the time is also technically in there. Just extract the date only any time you want to display it and ignore the time… as @yusaney1 said.
Hope this clears things up.
Gaby | Coaching Bubble
Private coaching, courses, and tons of free resources