Dateadd formula isn't working correctly

Topic Labels: Formulas
1398 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hi everyone! I’m using the Dateadd formula to add a certain number of days to a starting date to calculate a new date. For some reason, I have to include an additional day (32 instead of 31) to get the result to display ‘correctly’. Is there something I need to change in my starting date?Capture

2 Replies 2

When formulas with dates are off by a day it is almost always a time zone issue.

Check the formatting to see how the “use same time zone” toggle is set for both the formula field and the original date field.

If both fields show a time, you usually want to have both fields not use GMT time, but show local time.

If the original field is a date only field (no time), you usually want the formula field to use the “same time zone (GMT)”.

6 - Interface Innovator
6 - Interface Innovator

Argh . . . it worked!!! Airtable is so quirky like that - ugh. Thank you!!!