Date/Time Addition

[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

 

[Douglas J. Steele]

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

 

[Elwin]

You can use the DateAdd() function

Me!Next_Test = DateAdd("y", 3, Me!test)