Age formula showing zero for a patient that is 10 months old

[Garyjr123]

I need to know how to show months as an age for this formula. It will calculate only in years and if I have a patient that is 10 months old the formula shows 0 as an age when I really want 10 months.

// birthday feb 29 and current year is leap year
if month({pat.birthdate})=2 and day({pat.birthdate})=29 and
day(date(year(CurrentDate),3,1)-1)=28
then
if date(year(CurrentDate),month({pat.birthdate}),day({pat.birthdate})- 1) > CurrentDate
then year(CurrentDate)-year({pat.birthdate})-1
else year(CurrentDate)-year({pat.birthdate})
else
// birthday not feb 29 or current year is a leap year
if date(year(CurrentDate),month({pat.birthdate}),day({pat.birthdate})) > CurrentDate
then year(CurrentDate)-year({pat.birthdate})-1
else year(CurrentDate)-year({pat.birthdate})

 

[MCuthill]

GaryJr123,

A slightly different approach, as I am unsure you need to concern yourself with the leap year for this calculation.

With my Person Table, I created the following and it works - only those persons less than 1 month old show as zero's.

IF DateDiff("yyyy",{Date of Birth},CurrentDate) = 0 THEN
DateDiff("m",{Date of Birth},CurrentDate)
ELSE
DateDiff("yyyy",{Date of Birth},CurrentDate)

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[MCuthill]

GaryJr123,

And if the approach works for you, the following will also identify which measure is being used. (I should have thought to include it in my prior posting)

IF DateDiff("yyyy",{CIF.Date of Birth},Date(2011,06,30)) = 0 THEN
    ToText(DateDiff("m",{CIF.Date of Birth},Date(2011,06,30)),0,"") & " Years"
ELSE
    ToText(DateDiff("yyyy",{CIF.Date of Birth},Date(2011,06,30)),0,"") & " Months"

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."