Error in Time Zones when I send an Automated Email

[Andreanne_St-Ge]

Hi ! 

I've set up a time zone - which is the same for all collaborators - in events I plan in Airtable. However, when I send au automated email to my collaborators to let them know they've been assigned to an event, the time zone in the email is not the correct one, hence, they get the wrong time in their email assigning them to an event.

Is there any way to solve this? It seems weird that the automation changes the time setting...

Thank you so much!

[TheTimeSavingCo · Accepted solution]

Ah, you might want to try creating a formula field to display the date in the exact format that you want, and use that in your email instead

You can see my date field here is set to -5, and the formula field displays it fine

DATETIME_FORMAT(
  Date,
  'DD MMM YYYY hh:mm a'
)

And this is how I set it up in my automation:

And you can see that the date field displays a different date, whereas the formula field looks fine

This is down to the fact that Airtable stores the dates as GMT, which makes sense data wise but also leads to a bit of confusion sometimes

Link to base

[Andreanne_St-Ge]

Hey ! Thank you so much for the help. This worked out, but I really hope Airtable finds a better solution soon because it's really not instinctive and could lead to potential important errors on our end.

Have a great day!