… allright - I think I’ve got it now - and: @Jeff_Hager I’m using a combination, including your suggestion (thank you!!).
In general, here is what I found out:
- in a current version of glideapps the column type: “Date & Time” has a checkbox “Respect time zones” – this is helpful (in some scenarios) but:
- if I use “Date & Time” column type, enter the UTC time (i.e. 2024-08-22T17:00Z and check the box, the system will interpret as 5PM in my time zone (CDT) - thus, if I change zone in my system (to let say MDT), the Local time will be shown as 4PM (not 11AM as I’d expect)
So: in my case where I have a UTC date/time stamp and want to correctly present it across the time zones, while keeping that field intact, here is what I did:
- I kept my “matrix” date/time in text column: 2024-08-22T17:00Z (this one comes from google spreadsheet)
- duplicated it as a separate “Date & Time” column, without checking the “Respect time zones”
- created a TimeOffset column, using javascript: return -(new Date().getTimezoneOffset())/60, and finally
- created Local_Date math column, using Jeff’s
date + (TimeOffset/24)formula, where “date” is replaced with my “Date & Time” type column
whew… 
Thanks all to chiming in!
Here are screenshots:
