Date discrepancy between date picker and DB

I have a date picker in my app. When I use my live version and select a date and save it to my DB, it’s the same. However, when a user of my app does the same thing, the date is one day off from the date picker. Anyone know why that is or how to fix it?

1 Like

Is your user located in another time zone?

Yes. They are one timezone ahead of me

1 Like

This is the reason then.

Save the dates not using the current user time zone but rather a static one.

1 Like

I apologize. This is my first time venturing into building an app. How do you create a static time zone? Do you do that in a formula or is that a setting somewhere?

Date formatted as

It seems like that changes the value to a text. Do I just adjust by DB to a text field instead of a date field?

1 Like

Thank you so much for your help!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.