when using DateTimeDiff ([End_Date],[Start_Date],'days') for some of my data it results in negative values.
Example
Start_Date | End_Date | Result in Days |
2017-03-31 | 2014-06-02 | -1033 |
2018-01-01 | 2018-03-31 | 89 |
is there a workaround for this?
Thank you
Pete
Solved! Go to Solution.
If you'd like the absolute value of days, use the "abs(" function. The formula below would produce a value of "1033" for your first record.
abs(DateTimeDiff ([End_Date],[Start_Date],'days'))
Thank you Charles it worked like a charm. Your a rock star.