Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Subtracting dates in Reports — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Subtracting dates in Reports

Question
22
Views
0
Comments
edited Jan 15, 2015 4:15PM in Reporting and Analytics (TBE)

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!