Skip to main content

Time Zone Issue

  • December 20, 2022
  • 2 replies
  • 33 views

Forum|alt.badge.img+7

My base should only be Eastern Standard Time, but it keeps defaulting to GMT.   The devices I use it on are all EST.   What would cause this issue?   - Wendy

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • December 20, 2022

Airtable always stores all date/time fields as GMT. 


You can switch any date/time fields to “local timezone”. The same goes for any formula fields that produce date objects. If you have a formula field that produces a text string that looks like a date, use SET_TIMEZONE().


Forum|alt.badge.img+7
  • Author
  • Inspiring
  • December 21, 2022

Thanks.  I should have mentioned my field is set for local time zone.  It is filled in by automation and the NOW function.  I created a new field to set the time zone to EST, but the time isn't pulling in correctly.  It looks like it is defaulting to one time (7:00 pm).