I have a workflow that sends an email using a date that is stored in Glide.
When the email sends the date is “converted” magically to utc+0 instead of +11 which is my current time zone.
For example, 7:12 am should be 6:12 pm
How do I fix?
I have a workflow that sends an email using a date that is stored in Glide.
When the email sends the date is “converted” magically to utc+0 instead of +11 which is my current time zone.
For example, 7:12 am should be 6:12 pm
How do I fix?
Is the respect timezone option checked in the date column?
I start with a date (start):
then I do some maths to add a duration and get an end date:
Then finally I use both dates in a template field and that field is the body of my email:
Dates are correct in all Glide cols. When email sends we lose the TZ, I assume from the start col and it’s all down will from there ![]()
You were using Respect Time Zones here, I assume it’s stored as UTC+0 under the hood and it carries to your calculations.
You mention you are using a workflow, so another assumption here is the server looks at things in UTC+0, different from the usual “user” value, where they try to convert to your device’s timezone.
Question: Does it have to be a “respect time zone” setup?