Subtracting dates in Reports
I am trying to subtract two dates in a report to provide me with the difference in number of days. I created an expression, but it does not return the correct number of days and all the days are negative.
Here is the expression:
|Days (Second Contact - Submitted)||DIFF_DAY([REQU|REQU-REQU_CAND|REQU_CAND-INTV|CUSTOM_1268], [REQU|REQU-REQU_CAND|REQU_CAND-INTV|INTV-FEED|creationDate])|
For example: If the original date is October 2, 2014 and the First Contact is Octobert 5, 2014 the result would be -2
Does anyone know how to fix this to provide an accurate number?