Skip to main content
Question

Formula changes dates when asked to display date on record.

  • May 20, 2026
  • 1 reply
  • 0 views
A
Forum|alt.badge.img

I've created a calendar table synced to GCAL and wish to populate a calendar view with the events based on the Event Start and when Event Start is not available based on Event Created.

 

I've struggled to achieve this (I welcome any other possible solutions) so I attempted to create a formula field with the following formula: “IF({Event Start}, {Event Start}, {Event Created})”.  As generated by the ai agent.

 

Somehow that formula changes both Event Start and Event Created data.

 

I've also tried the following formula: DATETIME_PARSE(IF({Event Start} = BLANK(), {Event Created}, {Event Start}))

To the same effect.

 

Screenshot attached to quell my possibly insufficient description.

 

Questions.

  1. Why is the data changing when the formula is only requesting to display the data?
  2. Are my assumptions about the formula only asking to display data correct?
  3. Is my formula broken/insufficient? if so, what's the fix?
  4. Is there a simpler way to achieve my goal of populating a calendar view with the events based on the Event Start and when Event Start is not available based on Event Created?

Thanks for your time.

1 reply

DisraeliGears01
Forum|alt.badge.img+22

Classic time zone problem. Airtable is converting your event start/created fields into UTZ as that’s what it defaults to. 

Go into the formatting of your formula field and tweak the timezone settings. It helps at minimum to expose timezones so it’s clearer where things are, and set it to your specific timezone. Flights into different time zones might make things more complicated tho.

Terms & ConditionsAccessibility statement