In Access, future date from previous date

Copper Contributor

In Access, I'm trying to calculate a future date of 65 years from another date(birthdate) column/field. 

2 Replies
Here's one solution
DateSerial(Year(BirthDate)+65,Month(BirthDate), Day(BirthDate))

you can also use this and is more compact:

DateAdd("yyyy", 65, [Birthdate])