[Resolved]Date variable

[yousufkhan]

I am having a date variable strdate as date
i wanted to capture one month advance date from the present date in the
strdate variable

example presented date : 23/11/2004
strdate should be : 23/12/2004
how can i do this

[trisuglow]

Is this good enough? You may not be happy with the way it deals with Jan 31st...

Private Sub Command2_Click()
  Debug.Print DateAdd("m", 1, CDate("31/1/05"))
  Debug.Print DateAdd("m", 1, CDate("15/1/05"))
End Sub