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?
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