I know there’s lots and lots and lots of threads discussing the various head-banging difficulties involved in manipulating date/time objects. This is not an attempt to solve every single-dingle issue involved with dealing with date/times, but a lot of these discussions are about calendars and displ…

@keith @seanhoots Thanks for all that – I’m no longer wrapped around the axle. :slight_smile: What I heard was: For dates that people don’t associate with a time zone (like a birthdate,) save them as UTC, search for them in UTC, and format them UTC. In doing so, you can just use a single date fie…

Thanks @peng.o . I’ve got it working, but glad you jumped in with another option!

Yes, you understood what I was getting at! (sorry for the long note with lots of words) Again, if you wanted to compare vs. some other date, date range or whatnot in a datewise way, you can do a similar transform on the comparison date objects and remove any doubt about differences due to timezone…

Alternatively, you can use the unix value. The number of seconds passed since 1-1-1970 Add this in the API connector: [image] Then store a date, passed through this API, as a number in the DB [image] For display: [image]

I am reading this topic because of the same problem that the rest of you have had and it seems ridiculously complicated. When a user enters the date of birth surely it could be as simple as a setting to “Change timezone to” and set the timezone to UTC. We already can change the hours, minutes etc. A…

@keith made a plugin…I haven’t looked yet, but maybe it will help you. [image] New Free Plugin: Browser Timezone and Locale Showcase This is a little utility element I built to support my forthcoming set of Server-Side Action plugins. All this little guy does is return th…

Hi @arnold.smyth , I built an explainer app with an easier to follow method as well. See my replies and links in this thread: How To Schedule API Workflows Based On A Date In A Different Timezone Than Current Users Timezone I also have a forthcoming suite of server side actions that also help with …

I don’t think it will - what we need to do is take an input like: 13/02/2019 and save it as 13/02/2019 00:00 UTC. What is happening is that when I update the ‘thing’ in the DB it converts the date from whatever timezone I am in to the equivalent time in UTC and then saves it. There is no easy way ar…

Yeah, my BTZ&L plug-in is not specifically helpful in doing this date transformation (though it can be in certain contexts). Anyway, @arnold.smyth , you are correct that to make a date object in a zone, we take static values for the year/month/day and then construct a date in the zone. This can be …

Thanks @keith , I have looked at the moment solution and can implement it. My fear with this approach is the manual complexity - which I can do as the developer but the client may not be able to maintain if something goes wrong. It may be the only solution for now but a “Change to UTC” option in the…

An "Easy" Way to Convert Bubble Date/Times to the Same Date, but in a Different Timezone

Tips

mebeingken February 12, 2019, 3:09pm 18

@keith made a plugin…I haven’t looked yet, but maybe it will help you.

Topic		Replies	Views
[New Plugin] UNIX Converter Showcase	65	7347	April 30, 2019
Upcoming Updates to Timezone Handling in the Backend Announcements	32	6627	December 24, 2022
Date only (not time), into the database Need help	18	6537	March 10, 2021
Date and Time data structuring Database	21	12189	August 21, 2024
Solution for Adjusting Timezone / Date Picker / Server (UTC-GMT) Time Difficulties Showcase	19	10233	February 27, 2022

An "Easy" Way to Convert Bubble Date/Times to the Same Date, but in a Different Timezone

Related topics