Add months with last day

G

GrandMaMa

I know how to use the DateAdd command on adding months.

DateAdd("m", 45, ThisDate) However I need to insert the last day of the
month.

6/2/05 + 45 = 3/3/09 I need the answer to be 3/31/09.

Any Help is Appreciated

Granny
 
D

Duane Hookom

Try something like:
DateSerial(Year(DateAdd("m", 45, ThisDate) ), Month(DateAdd("m", 45,
ThisDate) )+1,0)
 
Top