Automation with Teams - Actionable Messages

[JWalker]

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.

[TheTimeSavingCo]

Hmm, are you referring to when the automation triggers?

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

[JWalker]

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.

[TheTimeSavingCo · Accepted solution]

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

[JWalker]

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

[JWalker]

Neither is working 😢

[TheTimeSavingCo]

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?

[TheTimeSavingCo · Accepted solution]

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:

[JWalker]

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