Calculate an age field in Access based on date of birth.

S

sunny

In Access 97, how can I convert a date of birth field (m/d/yy) to calculate
the actual years of age of the person?
 
R

Rick B

Have you searched? This is answered all the time.

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))
 
Top