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.
