Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Content

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!

Version

Feb 2017

Code Snippet

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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