Help

Date Formula Not Working Correctly

Solved
Jump to Solution
634 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_Cracknell
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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

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

Paul_Cracknell
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Paul