Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

DATEADD changes the time- ERRATICALLY!

Topic Labels: Dates & Timezones
Solved
Jump to Solution
341 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Annotation 2021-02-28 054811
A simple DATEADD is changing time.
SET_TIMEZONE(DATEADD(date,moredays,'days'),'America/New_York')

If it is because of daylight savings, does airtable recognize that and have a ‘fix’?

1 Solution

Accepted Solutions

It’s because of daylight savings. There is no fix for this. It’s super-annoying.

You can try asking support@airtable.com to fix this in the future, but they are typically a dead end. But it’s good to put your voice out there anyways about this issue, so they know that this is really messing people up.

Using Airtable is an exercise in practicing Buddhist meditation on a daily basis. Very little in Airtable is logical or consistent. Airtable is a minefield of little problems like this. Once you accept that the Airtable engineers are highly illogical and that Airtable is a very dysfunctional app, life becomes more peaceful.

I have not yet made it to that peaceful state yet. :stuck_out_tongue_winking_eye:

See Solution in Thread

1 Reply 1

It’s because of daylight savings. There is no fix for this. It’s super-annoying.

You can try asking support@airtable.com to fix this in the future, but they are typically a dead end. But it’s good to put your voice out there anyways about this issue, so they know that this is really messing people up.

Using Airtable is an exercise in practicing Buddhist meditation on a daily basis. Very little in Airtable is logical or consistent. Airtable is a minefield of little problems like this. Once you accept that the Airtable engineers are highly illogical and that Airtable is a very dysfunctional app, life becomes more peaceful.

I have not yet made it to that peaceful state yet. :stuck_out_tongue_winking_eye: