Format expression to calculate aging (date/time entered vs now()
Posted on 2008-10-16
Hello all. I am trying to build an expression so that supervisors will be able to look at the records and determine how long a document is pending. I have a field on my table with a default value of NOW(). What I need to do is create a query that will show how long the escalation has been open.
I used the following expression to try and obtain that value:
I need to format the values to reflect days:hours:minutes:seconds. Any and all assistance is greatly appreciated!