adding years to dates.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi.

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

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

-Michael
 
Back
Top