Skip to main content

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,

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. 🙂


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. 🙂


I’m gonna test it! Many thanks!!


Reply