Date differences

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Im a little stuck trying to do a datediff query.

i have two fields "request date" and "done date", and i need the query to
show all records which have a difference of 10 days or more. i.e. if it has
taken ten days or more from the date of request to the date of being done.

help!

Thanks in advance
 
In the Criteria row under your [done date] field, enter:
Is Null OR > [request date] + 10
 
You must log in or register to reply here.

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

Complex query 0
Creating an update query that uses multiple parameters 2
The query cannot be completed. 1
Parameter Query 8
Enumerate the Days (all the days) Between Two Dates (?) 1
Excel Vba to change displayed year automatically. 14
Help with Query syntax 2
Generating system date in Query 2

Back
Top