Age

[David Jondreau]

I know this has been answered but can't get the Search feature to cough up the right results.

Give a birth date and Get(CurrentDate) what's the calculation for an exact age?

Edited April 5, 2010 by Guest

[David Jondreau]

I took a stab at it and think this is right...Comments appreciated.

Let([

bday = table::Birth Date;

mBday = Month(bday);

dBday = Day(bday);

DateBday = Date(mBday; dBday; 2000);

today = Get(CurrentDate);

mToday = month(Today);

dToday = Day(Today);

DateToday = Date(mToday; dToday; 2000);

result = Year(today) - Year(bday) - ( DateBday > DateToday)

];

result

)

[comment]

Don't see why you need the 2000 thing:

Let (

today = Get (CurrentDate)

;

Year ( today ) - Year ( DOB ) - ( today < Date ( Month ( DOB ) ; Day ( DOB ) ; Year ( today ) ) )

)