Query within amount of days

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I haven't used access in about a year or too and I must have lost my
touch. I am trying to create a query that will show me the renewals
due within 2 months or 60 days. I cannot remember how to do this. I
already have:
Now()And

I don't remember how to say "60 Days" or "2 Months"
 
SELECT *
FROM YourTable
WHERE RenewalDate
BETWEEN Date() AND DateAdd("m", 2, 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

A within query 1
Criteria Question 2
Query for multiple due dates 8
Extracting Month and day from Date field 2
Excel Add 60 days to column 1 or column 2 based on whether column 2 has data 1
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Birthdays within five days 12
Update Query 10

Back
Top