Date Search With Query

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

Guest

How do i automatically search records for dates that are 7 months old in
access, through a query, without inputing a date range every time?
 
Ronnie

Take a look at Access HELP on the DateAdd() function. This will let you use
something like:

DateAdd('m',7,Date())

(actual syntax may vary).
 
Thanks, with a little bit of research, I ended up using

Between DateAdd('m',-7,Date()) And DateAdd('m',-6,Date())

to make it work the way i wanted to, but definately needed pointed in the
right direction. thanks again for your help!!!
 
You're welcome. Thank YOU for posting back your solution... it benefits any
others who are trying to do something similar.

Jeff Boyce
<Access MVP>
 
Back
Top