I am hoping this is simple for someone. In my insurance company database we have the birthdate of the client, but I would like their age to pop up in another field once their BDate is inputed- any takers?

Hi

try this calc ( UNSTORED )

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

Awesome. Worked like a charm. Thank you.

I used this as well, and found that it worked great for new records but will not look at my old records and change those, unless I actually enter the field and make some change.

Am I missing something in this that will auto update?

Thanks!

Do you have the calc unstored as Daniele had posted?

I didn't change any of the settings to "store" anything, so doesn't that make it "unstored?"

NO.

There is an Option to Turn Off Storage, otherwise, FileMaker will store the calculation when needed.

HTH

Lee

Ugh, it's been a long hard week with a database that is not being cooperative.

I had forgotten to change my field from "text" to calculation. Sigh...stupid mistake #142 of the day (or so it seems).

Thanks for your help!

When making the calculation make sure you go into storage options to make sure that the "Do not store calculation results" is unchecked. After that you should be fine.

Jason