Date/Time Addition

M

Mike Mueller

Is it possible to add in a date format? I have a field
(Test) formatted as short date. I have another field
(Next_Test) which will need to be Test + 3 years. I haven't
played with this yest as I am still setting up the form.
Any suggestions appreciated.

Mike
 
D

Douglas J. Steele

Use the DateAdd function. To add 3 years, you'd use DateAdd("yyyy", 3,
[Test])
 
Top