Hi Bubble Community, How is it possible to write into the database only the current date , excluding the time? mm/dd/yyyy Thank you so much! Jason

If the field is type Date, you cannot exclude the time. Which should be fine because when you go to display the date within your app you can choose the way to format the date.

The ‘Date’ type in Bubble records a precise moment in time (to the millisecond). So the ‘current date/time’ is effectively a ‘time-stamp’ of the moment it is created, to the nearest millisecond - that’s how it is recorded in the database. From that recorded ‘moment’ you can extract as much, or as …

Thanks, @adamhholmes and @lakossaack . Adam, I apologize in advance if this question below posses any confusion with duplication of asking the same question. Earlier I referenced you in a previous thread from a couple days ago while working on date/time questions. Does your above response (“that’…

As @adamhholmes said dates are recorded to the millisecond. Bubble uses the user’s browser time. This is the way it works. Perhaps you can capture the date and for the purposes of “date math” you can use date operators. A useful one to use dates starting at 00:00 time on that day is :rounded down. …

Thank you, Carlos. I’ll have to think about how to apply this. We as humans do a great job at “over thinking it” and making a fairly simple problem way more complex than it needs to be. I am certainly a student and it’s safe to say, even a master of that! Desired outcome: I am simply attempting…

@keith you are an expert in many things Bubble … and one of them is what I call “dates math”. I remember watching one of your videos where you explain the predicament of managing dates across time zones. If possible, could you post a link to that video?

You’re probably looking for this: [image] Live Bubbling with Keith: Let's Talk About Dates - Explaining the Basics of Dates in Bubble Tips Been a while since I posted a long-form video… Here’s a new 1 hour video where I talk about the basics of the much-misunderstood Date…

Thank you, @cmarchan & @keith . Keith is there a common way to display a day’s things? Look forward to watching the video you provided in an attempt figure this out. Thank you so much, Jason

If it is possible what would be the best approach (extracting just the date somehow)? If you mean to display it in the browser, you just reference the stored ‘date’ field and format it however you want to (e.g. Sunday 24th January, or 24/01/2021 etc) You can also choose which timezone to display …

See: Constrain a list of items created today

Date only (not time), into the database

Need help

keith January 24, 2021, 5:47am 8

You’re probably looking for this:

Topic		Replies	Views
An "Easy" Way to Convert Bubble Date/Times to the Same Date, but in a Different Timezone Tips	34	12165	November 3, 2023
Comparing Dates in Conditions, and Accounting for Timezones Database	33	5601	July 11, 2022
Date and Time data structuring Database	21	12240	August 21, 2024
Upcoming Updates to Timezone Handling in the Backend Announcements	32	6663	December 24, 2022
[New Plugin] UNIX Converter Showcase	65	7393	April 30, 2019

Date only (not time), into the database

Related topics