TIme Zone Change and Compressor

Answered
Andrew R Fox asked on February 26, 2024

https://www.flexmonster.com/blog/handle-time-zone-in-web-pivot-table
In reviewing the documentation above, it looks like dates will be stored in UTC and if they are served to someone in Eastern or Pacific time zones, they will appear a day behind due to time zone conversion. However when showing dates (rather than datetimes), this is problematic. How can I ensure that a date is served as it is represented in the SQL table to all users regardless of time zone?

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster February 27, 2024

Hello Andrew,

Thank you for reaching out to us.

Please refer to our documentation in order to learn more about managing time zones: https://www.flexmonster.com/doc/date-and-time-formatting/#set-time-zone 

We hope it helps. You are welcome to contact us in case other questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer