Date Formatting

Having an issue with Date formatting which seemed simple. Here is my issue. My primary key shows the correct EST time as the published date. I am trying to use for a gallery and used a field called Date Formatted with the following command. It works great but is off by 5 hours which I assume is GMT time. How do I format this primary key to take into consideration the GMT difference?

DATETIME_FORMAT({Date Published}, ‘MM-DD-YYYY hh:mm’)

You can use a formula like this to set the time zone:

DATETIME_FORMAT(SET_TIMEZONE({Date Published}, 'Europe/London'),'MM-DD-YYYY hh:mm')

A list of supported time zones is here:

Also, for a real deep dive into Airtable time zones, you can check out my training video & sample base here:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.