Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

DATEADD changes the time- ERRATICALLY!

Topic Labels: Dates & Timezones
Solved
Jump to Solution
955 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul1
6 - Interface Innovator
6 - Interface Innovator

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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: