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