Hello, I encountered a problem with a date/time picker. I have a system that clients use to book taxi transfers. The client chooses a date/time using the Date/Time picker (not a plugin, the default one). I encountered multiple inconsistencies but the most problematic one is it Saves the date/time one hour later in the database.
Can someone advise a way to make the date/time consistent throughout the whole app? (Note it shouldn’t change based on timezone)
It will store based on the user’s timezone. If I am in GMT+1 and save 8pm, then the entry in my database will be 7pm UTC. If you’re in UTC, you’ll see that as 7pm.
You can enable timezone overrides in your app settings → General → Advanced
I had the timezone override enabled but tried to disable it. It didn’t fix the problem tho.
Thing is, I have no specific user to tie the time to (I used custom states for each step and just create a new Booking in the database when completed).
One other thing that I realized is that it does store the date based on where the user is located somehow. Eg: client is in USA, makes a booking at 12:00 pm, I check the database and the date/time shows 6:00 pm.
What I really do not understand is where the inconsistency came from as I supported the same system for over an year, made no changes and one day it just crashed with no apparent reasons
Not really. It’s been happening for almost a month now so it wouldn’t make sense. Also I opened a ticket for this and the bubble support made a booking. The booking’s date wrote 12:00 pm for them but it was stored 6:00 pm in the database when I checked it. I can tell it’s a timezone issue by this (see screenshots below: the test user for bubble support that displays 12:00 pm and my database that stored it as 6:00 pm)
