Query for next week and month.

  • Thread starter Thread starter James Mckillop
  • Start date Start date
J

James Mckillop

I have a date field that I would like to set up a query
for. I would like to be able to go from Current day to a
week out and also a month out. I tried <Date()+7 and
<Date() +30 but it did not return what I wanted. Any
sugestions?

Thanks
James
 
I have a date field that I would like to set up a query
for. I would like to be able to go from Current day to a
week out and also a month out. I tried <Date()+7 and
<Date() +30 but it did not return what I wanted. Any
sugestions?

Thanks
James
Click to expand...

Try

BETWEEN Date() AND DateAdd("d", 7, Date())

or

BETWEEN Date() AND DateAdd("m", 1, Date())
 
Back
Top