Calculation field with a text result

[John Chamberlain]

I have a field that is supposed to change based on the current date, but it does not. The calculation is as follows:

 

Case (CAT'S AGE < 152; "KITTEN"; "ADULT") with the result being TEXT, and CAT'S AGE is defined as (Get(CurrentDate) -  DATE OF BIRTH) with the result being a NUMBER

 

When I enter a new record, and a date of birth, the calculation inserts the proper result. But what I want it to do is automatically update based on the current date whenever I open the file.

 

In other words when the current date is 152 days or later from the date of birth the field should change from KITTEN to ADULT automatically. The way it is working now the calculation works properly when the date of birth is firstentered, but the KITTEN/ADULT status does not change even when the difference between the two dates is greater than 152 days.

 

Mac, OS 10.9.4, FMP 11 Advanced

 

TIA

[comment]

CAT'S AGE is defined as (Get(CurrentDate) -  DATE OF BIRTH) with the result being a NUMBER

 

Make sure this field is unstored.

[John Chamberlain]

I think that does it - I had the KITTEN/ADULT Status unstored, but not the CAT"S AGE - Thanks for your help