Subtracting dates in Reports

Content

Hi there,

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?

Thank you!