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
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