adding years to dates.

[rhys]

Hi,
Ihave a form which contains a calendar and two text boxes. When a date
is clicked on the calendar it updates textbox1 with the date. I need
textbox2 to automatically update with the same date but 3 years in advance.
How do I do this. I know how to add minutes and hours on to a time but can't
work out dates

Rhys

 

[Michael H]

Hi.

Search Access Help on the DateAdd function. You probably want to use it
like this:

DateAdd("yyyy", 3, "ControlName")

-Michael

 

[rhys]

thanks mate

Hi.

Search Access Help on the DateAdd function. You probably want to use it
like this:

DateAdd("yyyy", 3, "ControlName")

-Michael