How do I calculate a past date with today's date in a query

K

Kim

Working in a query, I need to substract a past date with today's date and get
the number of days that an order is outstanding. I don't want it to prompt
me with the box "Enter perameter value". Can someone help me with this
formula.
 
F

fredg

Working in a query, I need to substract a past date with today's date and get
the number of days that an order is outstanding. I don't want it to prompt
me with the box "Enter perameter value". Can someone help me with this
formula.
Click to expand...

DaysOutstanding:DateDiff("d",[YourDateField],Date())
 
Top