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.

Date Formula Not Working Correctly

Solved
Jump to Solution
222 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, all.

I have a field (Original PD…which stands for Original Plant Date) and I want to add or subtract the “Adjustment” field to arrive at the calculated “Actual PD”. In the Actual PD field, I used a formula: DateAdd(Original PD, Adjustments, ‘Days’) and I get the resulting “Actual PD” field. The problem is the math is not adding/subtracting right.

For example in the first record “BR14A”. I have an Original PD of 12/12/2020, an “Adjustment” of 3…which should give me 12/15/2020. Yet the formula is kicking out 12/16/2020.

Any thoughts on jaw to get this right? Thanks for any help.

Paul

Screen Shot 2021-04-24 at 12.47.09 PM

1 Solution

Accepted Solutions

Check the formatting options for both {Original PD} and the formula field. Make sure that they have the same time zone settings.

See Solution in Thread

2 Replies 2

Check the formatting options for both {Original PD} and the formula field. Make sure that they have the same time zone settings.

Kouvonne - That’s it! Your help has been spot on every time. Very much appreciated…thank you.

Paul