Hiya Steve,
I use:
floor((d_date - d_Birth)/365.25)
The value 365.25 accounts for leap years.
>Does someone have a routine that calculates someones's age based upon the current date?
>
>I have written one, but it does not account for leap years so it's basically useless and I don't want to reinvent the wheel. It's probably a common routine out there.
>
>Thanks for helping me again.
kenweber
GCom2 Solutions
Microsoft Certified Professional