Calculating Number of Days Between sysdate and Update Date
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!
time_format(date_diff(sysdate(), CO$TESTOBJECT.UpdatedTime), 'DD')