>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.
YEAR(DATE())-YEAR(ldBirthDate) should get you close - just need to cater for date being before birthdate (month/day).