Question Expression for Days Outstanding

Ospenc1

New member
Local time
Today, 04:39
Joined
Aug 7, 2013
Messages
4
Hello All -
I am needing help in trying to figure out an expression that will show how many days outstanding an order is (if it is possible). So I need it to start calculating from date received and ongoing until it is identified as being closed in the "date closed" column. If this is not possible, please feel free to provide alternative solutions that you believe may be fitting.

Thank you so much!!!
 
You can use DateDiff to return the number of days:
Code:
DATEDIFF("d",#05/01/2013#,date)
 

Users who are viewing this thread

Back
Top Bottom