Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date Formula Not Working Correctly

Solved
Jump to Solution
1245 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