Skip to main content

When a form is submitted it shows the GMT date & time however when an automation email is sent it sent as UTC. Can someone please help me fix this.

Thank you.

Hmm, are you referring to when the automation triggers?

Or are you referring to how dates are displayed in emails perhaps?


Hmm, are you referring to when the automation triggers?

Or are you referring to how dates are displayed in emails perhaps?


Yes I have set up a trigger for an email to be sent but even though the time zone for my forms & data pages/interfaces show BST when the information gets sent on the email it is changed to UTC.


Yes I have set up a trigger for an email to be sent but even though the time zone for my forms & data pages/interfaces show BST when the information gets sent on the email it is changed to UTC.


Ah, try using a formula field with DATETIME_FORMAT and SET_TIMEZONE, and use that formula field in your email

https://support.airtable.com/docs/formulas-and-date-fields
https://support.airtable.com/docs/supported-timezones-for-set-timezone


Ah, try using a formula field with DATETIME_FORMAT and SET_TIMEZONE, and use that formula field in your email

https://support.airtable.com/docs/formulas-and-date-fields
https://support.airtable.com/docs/supported-timezones-for-set-timezone


Thank you I'll try this now. Appreciate the help!


Ah, try using a formula field with DATETIME_FORMAT and SET_TIMEZONE, and use that formula field in your email

https://support.airtable.com/docs/formulas-and-date-fields
https://support.airtable.com/docs/supported-timezones-for-set-timezone


Neither is working 😢


Neither is working 😢


Could you provide a screenshot of the data in your table, a screenshot of the email that's sent out, and an example of what you would want the email to show?


From your screenshot it doesn't look like you used a formula field with DATETIME_FORMAT.  Could you provide a screenshot of your formula field and the automation setup? 

Here's how my formula field looks:

And here's both fields in an email:


From your screenshot it doesn't look like you used a formula field with DATETIME_FORMAT.  Could you provide a screenshot of your formula field and the automation setup? 

Here's how my formula field looks:

And here's both fields in an email:


you're amazing thanks a bunch I've sorted it now!! 😊


Reply