I am working on a report that will calculate a person's age based on two dates.

Both dates are in a YYMD Focus date format.
AGE/I3 = DATE_OF_LOSS - DATE_OF_BIRTH;

This calculation returns the number of days between the dates. I am looking for a formula that would take the number of days and convert it to years. Or is there a built in function to calculate the person's age?

Thanks.

and dividing by 365 wont work because of the leap year thing, right?
you want exact age ? or just years?
If just years, take the year part of each date and subtract. if birth monthday LT current monthday, subtract 1.
If exact, ... you get the idea.

I figured I probably would have to do it the way you have described. I was hoping there was a built in function to do it.

Thanks for the reply.

How about DATEDIF ( DATE_OF_BIRTH, DATE_OF_LOSS, 'Y')??

Cheers

Andrew W

Working in HR we just divided by 365.25 to get the number of years.

We calculate the difference and divide by 365.25 to calculate age.

Never thought much about leap years in this process.