same date but 1 month after 2

[budich]

Hi Guys,

Does anyone know how to make a function for calculate a date with a function so the result is a same date but in the next month. Lets i make example :
I have a field date 27 february 2001 and I want make a function that can make a result in another field as 27 March 2001. Of course, I cannot just add [date]+30 because the sum of the day in every month not all same.
Thank you in advance
regards
Budi

 

[hellferret]

I think the DateAdd function should do this for you:


NewDate = DateAdd("m", 1, OrderDate)


The "m" says add some months.

The 1 says how many.

 

[Cagliostro]

Dim a As Date
a = Date
a = DateAdd("m", 1, a)
John Fill
ivfmd@mail.md

 

[budich]

Dear John and Hellferret,

Thank you for your helpfull threads, it is work!
see you
Budi