Calculating an age

[Pamflans]

I am very new to Filemaker...and have the 5.5 version. How could I calculate the current age of a person using the date of birth and current date? Is there any way to compare MMDD of DOB to see if it is >= to current MMDD, and then subtract the DOB YYYY from the current YYYY to get the current age? If the MMDD comparison is < could I take current YYYY minus 1 and subtract DOB YYYY? Or, is this impossible?

Pam

[Rigsby]

This is one solution that I used: (Remember that your separators may be different – in Europe we use a ; and not a ,)Some of the guys here will probably have a better sollution!

------------------------------------------------------------------------

Case( ZZ_Today_Month = ZZ_DOB_Month and ZZ_Today_Day < ZZ_DOB_Day ;

ZZ_Today_Year - ZZ_DOB_Year - 1;

ZZ_Today_Month < ZZ_DOB_Month;

ZZ_Today_Year - ZZ_DOB_Year - 1;

Birthday <> "";

ZZ_Today_Year - ZZ_DOB_Year;

"")

The ZZ_Fields are calculations that individually extract the Day, Month, and Year numbers!

Hope you can get your head round this!

Rigsby

[Pamflans]

Thanks so much! I will give it a try. I didn't find the ZZ thing in the book that I bought...I will have to look again and see if it is there or if I missed it! Again, thanks.

Pam