Forum Discussion

Copper Contributor

Jul 06, 2022

In Access, future date from previous date

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

isladogs
MVP
Jul 06, 2022
Here's one solution
DateSerial(Year(BirthDate)+65,Month(BirthDate), Day(BirthDate))
arnel_gp
Steel Contributor
Jul 07, 2022
you can also use this and is more compact:

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