Date/Time Addition

  • Thread starter Thread starter Mike Mueller
  • Start date Start date
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
 
Use the DateAdd function. To add 3 years, you'd use DateAdd("yyyy", 3,
[Test])
 
Back
Top