Return records 2 months out

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

Guest

Hello. I have a table with insurance policy information and need to get
policies with an Effective Date within the next two months of running the
query. So, if I run the query any time in August, I would need the query to
return all policies effective any time in September or October.

Any help is very appreciated. Thanks!
 
Hello. I have a table with insurance policy information and need to get
policies with an Effective Date within the next two months of running the
query. So, if I run the query any time in August, I would need the query to
return all policies effective any time in September or October.

Any help is very appreciated. Thanks!
Click to expand...

As criteria on the EffectiveDate field:

Between DateSerial(Year(Date()),Month(Date())+1,1) And
DateSerial(Year(Date()),Month(Date())+3,0)
 
Back
Top