I am trying to understand the logic behind date and time fields. When I have a field in one table that is just set as a DATE (no time), and I do a lookup of that date in another table with just DATE (no time), it adjusts the date to be one day before what I have set in the originating table. When I add the time I can see it is adjusting for timezone, but the date I have set it with my timezone in mind already?
Page 1 / 1
Hi @Faculty_Scheduling
Airtable stores all dates and times in the GMT timezone. If you check off “Use the same time zone (GMT) for all collaborators”, it does adjust the date and time. See this topic for more info.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.