Time Zones add a little bit to the equation, but it’s not too bad. I prefer to create a Timezones table so the solution is more flexible. I use a three part system that helps simplify anything I need to do afterwards with time.
- Timezones table that contains the adjustments for each timezone I’ll need to use.
- MyTimezone canvas variable that is a dropdown of all the timezone options from the Timezones table.
- CurrentTime canvas variable that reads in the current time and adjusts it to the chosen timezone from MyTimezone.
I added this set up to the Playground Doc - A Collection of Tips, Tricks, and Examples that you can copy. There are some other fun Coda tricks in that document as well.
