Add to date

R

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
 
C

Cheryl Fischer

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

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