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
You can use the DateAdd function in either VB or Access VBA.HTHVB Code:
Dim strDate As Date Dim strDate2 As Date strDate = "23/11/2004" strDate2 = DateAdd("m", 1, strDate) MsgBox strDate2 '23/12/2004