Posted: 17 Nov 2017 0:13 EST Last activity: 21 Nov 2017 6:17 EST
"Datetime Difference" function in report definition
We would like to have a column in our report definition where we would like to calculate the difference in DAYS between two datetime properties. But, some times this function is giving NEGITIVE values like -2222+ etc in few cases.
I tried to calculate the Difference in days between two date time properties function as shown in the attachment and it is returning the results correctly. If you are passing the two property values to the function then may be you can look into the dates of those records which are displaying negative values in the report definition if you might have included those 2 properties like mine.
Hope this way you can figure out the root cause of your issue.