Seeing that all date/time stamps that happen on a server side workflow are captured in GMT, I’d like to have a computed action in the server side workflows to convert a time to a specific time zone.
1 Like
For example, I have a workflow that sends email reminders about upcoming appointments. I’d like the workflow to use a timezone stored in the user table for the appointment date/time.
1 Like
Can’t you already do this? 
I cannot. I’m open to suggestions though.
Date math can be so complicated. I’d like to select a time zone and let the computer do the work.
If you know each users timezone offset, can’t you just apply that in the workflow?
The offset can be variable like in Arizona where parts don’t follow daylight saving time. I wish I could find the youtube video that covers the complications. I’d like to select a location from a dropdown and use the work that people have already done rather than redo it.
This one? 
2 Likes
Ha! That’s EXACTLY the video I was looking for. How’d you do that?!
Do what? Find it? I know it very well, I must have watched it at least a dozen times or more over the years. Just Google for “Computerphile timezones”
Maybe two values are stored for date/times where the TZ option is selected.
- The GMT value
- The TZ value
It seems like when we select TZ option, the date is still stored as GMT with an offset applied but when the field is used in calculations then it uses the GMT value.
If TZ is selected the TZ value is always used (however that is calculated in practice). Because once I tick TZ I clearly don’t want to use the GMT value any more.
The world would be a simpler place if we only had one time zone. I suggest we all adopt the one France uses 
Not sure I’d like that. I’d be going to bed at 4 in the afternoon and waking up at midnight 
1 Like