Display datetime in different timezone

[skwaler]

I am storing timestamps/datetime in UTC.

I would like user when viewing the timestamp in datapage to see this time converting into their timezome

Either by looking up timezone preference from a users table or setting timezone view from a page item.

Is there anyway to do this?

[PotatoMato]

Hi @skwaler

 

You may achieve it using localization: https://howto.caspio.com/localizations/localizations/

 

-Potato

[PotatoMato]

You can also refer to this forum post: 

 

[skwaler]

@PotatoMato I don't want the timezone used to store the value to change. I always want to store at UTC.

But when reviewing the value in a datapage, i want to show the time in the timezone of user that is viewing the record.

I would imagine we need to use some JavaScript to convert the a chosen timezone?

[Talbot]

With Time Zones and Local Time, we use Google Maps to retrieve the Local Time and Time Zone and UTC Offset and then if necessary we use or display that local time.

Then no need to do ongoing data maintenance of Time Zones, etc. Works well

I have the code:   dtalbot@workmovr.com 

[Kurumi]

Hi @skwaler - You are correct. You may check these links for reference:
https://www.delftstack.com/howto/javascript/initialize-javascript-date-to-a-particular-timezone/
https://techbrij.com/date-time-timezone-javascript-select