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