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 2017Code Snippet
time_format(date_diff(sysdate(), CO$TESTOBJECT.UpdatedTime), 'DD')
Tagged:
2