Todays Date + 3months

  • Thread starter Thread starter Elvis72
  • Start date Start date
E

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?
 
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
 
Back
Top