>Hmmm... switching the floor function to a round() as in Microsoft KB Article
How To Calculate a Person's Current Age solves this particular example. Are there other instances where this does not work? If so, perhaps MS should remove/replace this entry.
>
>So, can we all agree on a single best method to be used along with an explaination why to be posted as an FAQ? Perhaps including "Why Not's" for other methods.
>
>Thanks for pointing this out Joe!
Ken,
This discussion has occurred before and there is an age calculation UDF in the libraries here that works for all conditions and all situations.
A comment to the original poster, don't store the age in a field because it will not be accurate later.