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
Printable View
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
Is this good enough? You may not be happy with the way it deals with Jan 31st...
VB Code:
Private Sub Command2_Click() Debug.Print DateAdd("m", 1, CDate("31/1/05")) Debug.Print DateAdd("m", 1, CDate("15/1/05")) End Sub