Date Output different than on Base

Question

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 Answer

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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded