How do I add Time to a Date

zachenson · 2020-06-22T22:58:18.874Z

Hi I hope this is a simple question but it has been bugging me for quite some time. I have a Date Picker and a Time Picker. How do I save (or combine) the Date and Time into one entry in the database. Basically right now I have June 22, 2020 and I have 4:00 PM as two separate entries. How do I save them as June 22, 2020 4pm?

ambroisedlg · 2020-06-22T23:03:51.997Z

Hi @zachenson

When creating a Thing, you can set your field Date = Date Picker’s value:change hours to Time Picker’s value:extract hour:change minutes to Time Picker’s value:extract minutes:change seconds to Time Picker’s value:extract seconds

Let me know if that does the trick

keith · 2020-06-23T02:56:55.444Z

Dates ARE times. Read everything I’ve written on this topic, especially watch this:

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 data type in Bubble. Covering what dates are and why we need them, explaining that dates are times, explaining the difference between date construction and date formatting, and showing the new “Utility” features in Calendar Grid Pro. This might be helpful to anyone who has struggled with dates or who wants a better understanding of the basics of dates. Also, I n…

zachenson · 2020-06-23T04:23:56.668Z

Wow thank you @keith that is a very thorough overview of how dates (time) works in Bubble. Much appreciated.

zachenson · 2020-06-23T17:53:32.150Z

@keith I really appreciate your video. I feel like it would be really helpful if @emmanuel or someone from Bubble put together an official video or lesson on how time works in Bubble. I think its a pretty big topic (hence why @keith made the video) that is difficult to understand with current Bubble documentation.

pratima.dudhewar · 2023-01-04T12:49:09.905Z

@ambroisedlg
I have HTML element i.e. time picker where i’m getting result in text format and so then i’m running another javascript code for text to date conversion.
But result is not what exactly it suppose to be. I want to perform action like +(minutes):60 to date.
How can i achieve this?