Access 2010 update: add 1 year to a date

[bwian1234]

Hi, I know this must be easy, but I can't get an answer.
I'm using Access 2010

I have a field, 'Year End', this contains a date.
I have an update that adds 365 days to this date

The criteria I have is :-
Field: Year End
Table: delrun


Update to: Date()+365
Criteria:
Or:

SQL is:
UPDATE delrun SET delrun21.[Year End] = Date()+365;

How do I add exactly 1 year?

Thanks in advance

Tony.

[CJ_London]

use the dateadd function

Update to: dateadd("yyyy",1,Date())

[JoeM]

You can use the Access DateAdd function. It allows you to add any interval (days, months, years, etc).
See: https://www.techonthenet.com/access/...te/dateadd.php