Agonizing over inconsistent timezone behaviors

[Caedan]

Hi,

I’ve been agonizing over a set of behaviors regarding dates between Airtable and my bubble app.
I don’t even really understand the behavior here but essentially when the user’s timezone is anywhere in Australia, a day will sometimes but not always be subtracted. IE, June 20 becomes June 19. This happens to some users in American timezones as well but not always.

We started out with ‘Users own timezone’ as a default and have since tried every variation of the static timezone options - the issue has remained the same.

I simply need the date to stay the same when it’s saved from bubble to airtable and vise versa. The specific time of day doesn’t matter. I’d rather not save everything in plaintext because it means I have to spend a hundred billion hours reworking all my workflows.

Any help would be immensely appreciated. xoxo

[cmarchan]

Hello @Caedan

Storing dates in both systems in UTC time should help

[Caedan]

The main issue here is that the user’s own timezone seems to be affecting the input when it’s not suppose to be. I’ve tried having both dates in GMT which worked for a while, but then the issue started popping up again. It’s the inconsistency that’s confusing.

[cmarchan]

Hello @Caedan

This post should help:

How to setup dynamic time zone for users?

You will need to create “Preferred Timezone” text field on the User type and initialize it on page load if it’s empty. To get current browser’s timezone, use script from here: timezone - Getting the client’s time zone (and offset) in JavaScript - Stack Overflow, invoke it using Misha’s Toolbox Plugin | Bubble and populate timezone in JavascriptToBubble element. Now you can initialize your timezone field when it’s empty. Next step is to add Preferred Timezone field to User Prorfile page and to …