Date Output different than on Base

[Sierra_Van_Ryck]

Hi!

I am trying to set up an automation so that when we update the record, an email is sent out to a client with the updated notes.

However, when I use the date link in the Automation, the email test comes back with “2020-10-30T18:04:00.000Z” as opposed to the US format (10/30/2020 at 6 pm). Am I missing something that is causing this to come out this way?

[ScottWorld · Accepted solution]

Please see here:

"Date field" records have non-human readable format on Twitter Automations

Welcome to the community, @Ferran_R! Instead of sending your original date field to Twitter (which only sends the underlying date data, like you’ve seen), create a formula field in Airtable that is formatted in the way that you want, and then send that formula field to Airtable. You can find a list of the supported date format specifiers here: So, in your case, your date formula would look like this: DATETIME_FORMAT({Your Date Field},'DD/MM/YYYY HH:mm') Note that this formula will use GMT…

[Sierra_Van_Ryck]

Thank you so much! I had been struggling with this for so long.

[ScottWorld]

You’re welcome! Glad I could help! :slightly_smiling_face: