Age calculation

[aria]

Hi all,

I have the following age calculation that outputs such as year “12”

Is there a way to make the output year and months such as “12.3”

Let ( [

Date1 = id::id_birthdate;

Date2 = abc_date

] ;

Case ( not IsEmpty ( Date1 ) ;

Year ( Date2 ) - Year ( Date1 )

- ( Date2 < Date ( Month ( Date1 ) ; Day ( Date1 ) ; Year ( Date2 )))

)

)//result number

Thanks for any help. :

A

[Søren Dyhr]

How about:

Let(

    [ Date1 = id::id_birthdate; Date2 = abc_date ];

    Round(

        Case(

            not IsEmpty( Date1 );

            Year( Date2 ) - Year( Date1 ) +

            ( DayOfYear( Date2 ) - DayOfYear( Date1 ) ) / 365

        );

        1

    )

)

)

//result number

--sd

[aria]

That did it

Thanks,

A