Time Converts to UTC in Email Automations

Whenever I include Date & Time fields in email automations, the time gets converted to UTC. Is there a way to prevent this?

Thanks!

Hi Joel,

Date fields are always shown in UTC yes, if you need a certain format / timezone you can use a formula field with DATETIME_FORMAT() and SET_TIMEZONE()

2 Likes

Thanks Mohamed! I guess that’s a solution. I have a lot of time fields in this table and I’d rather not have to make and reference helper fields for all of them.

My time zone base & training video might help you with the conversions that you’ll need to make:

1 Like

Thanks Scott! I do love your template! The trouble is that the fields I’m using are just supposed to reflect dates and times that were entered into forms on our healthcare record system by users, and all that matters is that the date shown in the field is exactly the same as what others using the system will see on that record. There’s no need for time zone conversions or anything, and they actually screw things up. I want it to just act as raw data reflecting the dates and times entered by the staff when they filled out the form. I wish there was a setting for the Date/Time fields that would allow for this without having to jump through a bunch of hoops with formulas, etc. It works when users are actually in Airtable–it just shows whatever date and time was entered in the field. But in my use case, most users won’t be going into Airtable. They’ll be getting email messages with the content of form submissions, and I just want the dates/times in those emails to look the same way they do in Airtable–not converted to UTC.

Did you already turn on the GMT option for your time fields, so the times are always consistent? Then, what you see in your base is what Airtable will also see behind the scenes. No conversion necessary.

Otherwise, just create a formula field that results in a text string of you want to see, and reference that formula in your automations.

Yeah, I have the GMT option turned on, but it still changes the times in the automated emails. I wish I didn’t have to create helper fields, as we use a lot of date/time fields. How would I write the formula to make the automation show exactly what the GMT field shows?

Oh, that’s very interesting! So it’s still adjusting the time in automations beyond what you see onscreen as GMT? It sounds like you probably need to play around with this by creating some formulas that use the SET_TIMEZONE function. You can play around with some of the formulas in my sample base above.

p.s. Alternatively, I talk about Make.com a lot because I use it with many of my clients, but Make.com makes it much easier to work with timezones than Airtable. You can use their built-in time zone function, and it also offers advanced scheduling of automations in the time zone that you specify.

1 Like