Help

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

1235 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Ferran_R
4 - Data Explorer
4 - Data Explorer

Hello,

when I create an automation to publish to twitter events with a specific date.
This field appears like this on the tweet:
2020-09-30T15:45:00.000Z

Instead of a more human-readable format.

I want to get something like this: 30/09/2020 15:45?

Thanks,

2 Replies 2

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 Time Zone for your time. So, if you’d like to convert the time to a specific time zone, then use this formula:

DATETIME_FORMAT(SET_TIMEZONE({Your Date Field}, 'Europe/London'),'DD/MM/YYYY HH:mm')

You can find a list of supported time zones here:

Also, for more advanced time zone functionality, you can refer to my sample time zone base & time zone training video:

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

I’m gonna test it! Many thanks!!