Adding a year to the current one?

[sp00k]

Hello, I have a field where it says date a certificate was purchased, but I would like another field that displays the same date, but only a year from when it was purchased.

AnnualInspectionCertificateExpiry is the name. I've tried adding 0/0/1 but it doesn't seem to work.

Thanks!

 

[namliam]

Lookup the Dateadd function in the access help, you will love it

 

[sp00k]

Heh, I just found it.
DateAdd("M",12, tblVehiclesDatabase.AnnualInspectionCertificateExpiry) As AnnInnDueDate

Seems to work, I tried "Y", 1 but that only changed the day for some reason..?

 

[neileg]

"Y" means day of year, "YYYY" means year.

 

[namliam]

RTFM or... read the help on what parameters you can use

for year it is "YYYY"

 

[sp00k]

RTFM... Microsoft must have missed putting a manual in my access packaging.
I had my date formatted YY so i thought YYYY, I wouldn't work, didn't explain that in the help files.

 

[namliam]

From the access help:
Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second

 

[MSAccessRookie]

RTFM... Microsoft must have missed putting a manual in my access packaging.
I had my date formatted YY so i thought YYYY, I wouldn't work, didn't explain that in the help files.

By Manual (these days anyway) I think he means use the Help Option and read the results