Calculate Age in years, months, or days 1

[Buckaroo8]

Hi All,
I have three numeric fields to work with:
BirthDay
BirthMonth
BirthYear

How can I utilixe them to calcuate a persons age in Years, or if younger, months or days?

i.e. the result will appear either:
21 y
7 m
18 d

Thanks for all help!

 

[MrBillSC]

Use the Date and the DateDiff functions.

Date(Birthyear,Birthmonth,Birthday) will treat these fields as a date, then use the datediff function to calc the age.

MrBill

 

[synapsevampire]

A datediff of years against a date will give you the wrong age as date diff will only compare the years.

Here's an example for a real age:

http://www.kenhamady.com/form06.html

Use a formula akin to MrBill's in the formula, as in:

cdate({table.byear},{table.bmonth},{table.bday})

-k