Age

[Mattg-zzz]

I have a field with the persons birth date and I want to add a field that will show thier current age. Anythoughts.

[-Queue-]

Use an unstored calculation field of

Year(Get(CurrentDate)) - Year(dateofbirth) - (Get(CurrentDate) < Date( Month(dateofbirth); Day(dateofbirth); Year(Get(CurrentDate)) ))

[Mattg-zzz]

Thank you, that worked great.

[Lee Smith]

Yes, I have a thought.

Learn how to use the Search Feature of this Forum. There are many, questions that get asked over and over again, and this is one of them.

I just did a search using [color:blue]+Birthday +Calculation and got several threads on this subject. (include the plus sign with the words. Also, there is a ? icon above the Keywords you should review.)

You might want to look at this recent post:

by Clicking HERE

Lee