age calculation

[bugsbunnyy]

Another likely easy question (I'm new to FM)

I have 2 fields, today's date and date of birth.

How can I calculate a person's age based on these 2 fields? Thanks

[email protected]

[Chuck]

This is a calculation that will do what you need:

code:

---

If(IsEmpty(Birthdate), "",

NumToText(

Year(Status(CurrentDate)) - Year(Birthdate) - Case(Status(CurrentDate)< Date(Month(Birthdate), Day(Birthdate), Year(Status(CurrentDate))), 1, 0)

)

& " Years, " &

NumToText(

Mod(Month(Status(CurrentDate)) - Month(Birthdate) + 12 - Case(Day(Status(CurrentDate)) < Day(Birthdate), 1, 0), 12)

)

& " Months, " &

NumToText(

Day(Status(CurrentDate)) - Day(Birthdate) + Case(Day(Status(CurrentDate)) >= Day(Birthdate), 0, Day(Status(CurrentDate)- Day(Status(CurrentDate))) < Day(Birthdate), Day(Birthdate), Day(Status(CurrentDate)- Day(Status(CurrentDate))))

)

& " Days"

)

---

Chuck

[Garry Claridge]

Here is how we do it with a calculation field:

If(DayofYear(Today) < DayofYear(dob), (Year(Today) - Year(dob)) - 1, Year(Today) - Year(dob))

Hope this helps.

Garry

[bugsbunnyy]

much obliged; works great; thanks