Date timezone bug

Ask the community
1

We have noticed that when we set the date on a field in UI to 15.01.2006 the database seems to push the date back by an hour++, seems like the UI and the database are using different timezones. When i set the date to 15.01.2006 the time of day is set to 00:00:00, so the database show 14.01.2006.

The UI still displays 15.01.2006, we are sending these dates to an API, so they need to be accurate.

2

Hello Henrik,

This is not a bug. Datetimes are stored in the database as UTC, while the UI displays the time based on the app time zone. However, you may use “Update object in App Variables” to change the built-in property App Time Zone to UTC. You may read more about dates in the documentation.

1 Like