Skip to main content

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 pory.io 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:


Reply


Terms & Conditions