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

G

Guest

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())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date range in a query 1
how to calculate hrs flown in last one year 0
Autoinsert of variable data into update query 6
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16
Use DATE in query expression 1
DateFunction in Query 19
Calculate Diff Date? 3
Using today's date in a query 2

Top