DateTimeDiff produces negative days

[pvara]

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

[CharlieS · Accepted 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'))

[pvara]

Thank you Charles it worked like a charm. Your a rock star.