add month to date

[smayshar]

hello, I want to add 26 month to a given date how do I receive the correct date result
thanks

 

[PHV]

Take a look at the DateAdd function:
newDate = DateAdd("m", 26, oldDate)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[smayshar]

Thanks very much it works fine !!!