Help with age script

[mnoh84]

Hi Guys,

I'm a total filemaker beginner with some very minor programming experience.

So I am designing a database for my psychology lab where workers can input the birthdates of subjects and their age in months and years will automatically be calculated into a separate field. Right now I have it set up so that the value for the age field is calculated using:

Int((Status(CurrentDate) - birthdate) / 365.25) for years and

Int((Status(CurrentDate) - birthdate) / 12) for months

My question is how to get these fields to autoupdate once they change. For example, if I create a new record for a subject that is 9 months old, I don't believe that right now the subjects age will change to 10 months one month after they are entered into the database. How do I change this so the subjects' ages are always accurate regardless of when they were entered into the database?

[Lee Smith]

You need to change then calculations to Unstored.

Select the calculation field in the Define Fields box, click on Options, then click on Storage. Select the checkbox that says "Do not store calculated results.

You might also want to do a search for Birthday calculations.

Lee

[mnoh84]

Thanks Lee, but I can't find the storage options on my version of Filemaker. Could this be an option that was included in later versions and not on 6.0?

[Lee Smith]

I gave you the steps, after going into Define Fields. You just need to open of the Define Fields, as follows.

Main Menu >> File >> Define Fields (Command + Shift + D)

You might