Sep 25, 2020 09:04 AM
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,
Sep 25, 2020 09:50 AM
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:
Sep 25, 2020 09:53 AM
I’m gonna test it! Many thanks!!