Todays Date + 3months

[Elvis72]

I have a query that has a Mobilization Date and a Demobilization Date where I
need to show everyone that is Mobilizing and Demobilizing from todays date
plus 3 months.

Right now I have this:

DateSerial(Year(Date()),1+Month(Date()),1)

Which gives me 1 month going forward, how do I increase this range to 3
months?

 

[Michel Walsh]

DataAdd("m", 3, date())


will return a date in 3 months from today. Sure, if you need that date to be
the first of that said month, use

DateSerial(Year(Date()),3+Month(Date()),1)



Vanderghast, Access MVP

 

[Al Campagna]

Elvis,
Try the DateAdd function...
DateAdd("m",3,Date())
So, for a range...
Between Date() and DateAdd("m",3,Date())
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Elvis72]

The Between dates code worked great!~

Thanks soooo much!~