Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

DateTime add is not working correctly

Topic Labels: Dates & Timezones
151 1
Showing results for 
Search instead for 
Did you mean: 

Here’s all the info:

The formula is subtracting time when it should be adding time.

Here’s the beginning time settings

Here’s the formula settings

It should be adding one hour to the time, but instead it’s subtracting 7 hours.

Any help would be great!

1 Reply 1

Those 2 fields are in different time zones. You’ll need to adjust your formatting on each field to have matching time zones.