Add to date

[Rick]

I have a date field that is used to track training, I
want to add 3 years to that date, which would be the due
date of next training. Can anyone help.
so if my date is 5/26/04 I want the new field(or text box
on a report) to be 5/26/07.

Thanks Rick

 

[Cheryl Fischer]

You can use the DateAdd() function, for example:

DateAdd("yyyy",3,[TrainDate])