Calculating Number of Days Between sysdate and Update Date

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')