formula to calculate age from date of birth

[Guest]

Can someone help with above. I have got DOB but want to work out their age.

 

[Guest]

Hi,
The Datediff function should be able to figure out the age up to day.

Datediff("yyyy", DOB, Now())

 

[Rick B]

That does not work. It does not take into account if the birthdate has
passed this year, or is coming up.

You would use...


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

Please note: This question is asked in this newsgroup often. In the
future, you might try doing a search before posting your question.



Rick B

Hi,
The Datediff function should be able to figure out the age up to day.

Datediff("yyyy", DOB, Now())

age.