I have datetime columns.
I stringify them with template columns.
I query those stringified values in a manual trigger and send them in an email.
The times in the email show up 4 hours later than they should.
What am I missing? Do I use a different column type? Template column to stringify has always been reliable…
Your date is most likely being stored in UTC time and converted to EDT when you view it. The server only sees UTC time, and thus the template column is “locking in” at UTC time, and applying a 4 hour difference, but I’m the wrong direction.
To be honest, I think Glide handles dates and times very poorly. It’s definitely a timezone issue because you are -4 hours from UTC time. Glides handling of time is weird in that they can both completely ignore the zulu (UTC) timezone indicator in an ISO date, while also allowing conversion to and from zulu time without explicitly specifying a timezone. It’s hard to understand what they are doing and they have never explained the logic behind it very well, or at all. Their handling of date logic has been flawed from day one in my opinion. I would guess it’s a side affect of them trying to interpret external string based dates as actual dates, which can be difficult when data is coming from a google sheet for example, but in my opinion they could definitely handle it better, especially if they are storing the UTC ISO underneath.
Since you are using a server side workflow, it’s either trying to unnecessarily apply all of this extra timezone conversion logic or just doing it in the wrong direction. Maybe you can get away with applying a timezone offset to your date column to account for that, or maybe you have to double the timezone offset value first. Not sure, but there definitely needs to be some workaround manipulation to get it to work correctly at the moment.
There needs to be a lot more control of that logic from our end instead of them trying to incorrectly figure it out for us.
Well, I completely agree with your assessment. Thanks for weighing in. I will attempt to try to find a work around here.