Figuring out current age

[Poida]

Can anyone tell me if it is possible to have a field that tells me the current age of a person in Years and Months from a Date of Birth Field??

Many thanx in antici..............

pation

Poida

[Lee Smith]

Here is one.

NumToText(Year(Today) - Year(Birthday) - Case(Today< Date(Month(Birthday), Day(Birthday), Year(Today)), 1, 0)) & " Years, " & NumToText(Mod(Month(Today) - Month(Birthday) + 12 - Case(Day(Today) < Day(Birthday), 1, 0), 12)) & " Months, " & NumToText(Day(Today) - Day(Birthday) + Case(Day(Today) >= Day(Birthday), 0, Day(Today- Day(Today)) < Day(Birthday), Day(Birthday), Day(Today- Day(Today)))) & " Days"

Lee

[Poida]

Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou Thankyou

[Vaughan]

AK! Don't use Today, use the Status(CurrentDate) function.