[Resolved] date into 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

[RobDog888]

You can use the DateAdd function in either VB or Access VBA.

Dim strDate As Date
    Dim strDate2 As Date
    
    strDate = "23/11/2004"
    strDate2 = DateAdd("m", 1, strDate)
    MsgBox strDate2 '23/12/2004

HTH