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

Calculating Number of Days Between sysdate and Update Date

Accepted answer
edited Jul 18, 2018 2:43PM in Reporting & Analytics for B2C Service 6 comments


Hi all,

I have a column in my report to display the number of days between the current date and the date the record was last updated using some report functions. Though the number of days being displayed are correct in most cases, I'm experiencing some unexpected output. For example, the same number of days is being displayed where some records have different updated dates. I've included a screenshot that illustrates this. I suspect it my have something to do with the fields being datetime, but am unsure.

Any insights would be appreciated!


Feb 2017

Code Snippet

             time_format(date_diff(sysdate(), CO$TESTOBJECT.UpdatedTime), 'DD') 

Howdy, Stranger!

Log In

To view full details, sign in.


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