: > |birthday |

: > |_a,calc (today-_a)/365.25 as age|

: Ah!, but that's not *exactly* correct. Suppose you have an application where

: there is a specific cut off date, and you want to find those people who are

: *strictly* at a certain age on that day. The above calculation can give an off

: by one error, which is dependent on leap years.

: I haven't found any simple way of solving this problem. If anyone knows

: of one, then I'd be interested to here it. For now, I have accepted the

: possibility of the error.

: Mike

Well, if you do an integer truncation of age, I believe it works ok. The

error gets larger until leap year, then it catches up. But you are

truncating it off anyway. Besides, I use the above query for doing election

demographics. So I only need to know ABOUT how old people are.:') Don't

know what the original questioner is doing. For my data, the fractional

error is the least of my worries. The county clerk's file only carries the

year of birth to 2 digits, so I have to trap for people "younger" than 18.

Yes, there are a few people in my data set with ages less than zero...

What happens in a leap century? We've only got a little while to figure

it out. But then, I guess we'll be better off than the COBOL programmers:-)