Skip to main content

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

  • September 25, 2020
  • 2 replies
  • 0 views

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

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8764 replies
  • September 25, 2020

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:


  • Author
  • New Participant
  • 1 reply
  • September 25, 2020
ScottWorld wrote:

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!!


Reply