VBA Date From textbox.

[DanJames]

I need the VBA to take a date from the textbox "NewDate", add 3 months onto the month and then place the new date into the textbox "DueDate". Ive done this before but have forgotten it, Something like:

Date Day("NewDate"), Month("NewDate")+3, Year("NewDate")

But have forgotten something, any ideas? Thanks, Dan.

 

[ajetrumpet]

look up the dateadd() function

 

[DanJames]

Thanks mate, that worked great.