calculating dates + 3 yrs

G

Guest

Can anyone help me?

I have a Table with staff details. One column is TRAINING DATE and one
column EXPIRY DATE. Training date is the date of First Aid certificate to be
updated and Expiry is the next date to renew certificate which is in 3 yrs.
So a training date of 20/11/2001 will be updated in Exp date to 20/11/2004.

Is there a way of getting the EXPIRY DATE to automatically be entered when
Training Date is inserted? Once Training Date is entered the Exp Date will
auto enter adding 3 yrs on the year.

I have tried =DateAdd("y", 3, 20/11/2001") and
=DateAdd("m", 36, [Training Date])

Is there a way of calculating this TRAINING DATE + 36 = EXPIRY DATE (+3yrs)
Is there a DateSerial formula?

Thank you very much,

Kim Johnson
 
G

Guest

Hi Kimla,
I can do the function DateAdd in query and form, but I can not do it in table.
I hope this answer your questions.
 
R

Rick B

I woul think that =DateAdd("yyyy",3,[TrainingDate]) would work.

You would put this in an unbound field on your form.

You would NOT store this in your table, because the figure can be calculated
when you need it and storing it would be redundant. Just use the above
formula in queries, reports, and forms when you need to see the date.

Hope that helps,

Rick B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top