[RBASE-L] - Refreshing Calculated Field in Table

[Patrick Murphy]

I have an calculated integer field in a table that determines a person's age.  The calculation is:  (IFNULL(ChildBirthday,0,((.#date- ChildBirthday) / 365.25)))      I just discovered that the calculated age has not automatically updated for persons with birthdays in the last several months.  So someone with a 4/1/2003 birthday is still showing an age of 1, rather than 2.  Current system date is correct.  I edited the column definitions and forced a table save, and that did result in the ages being refreshed, but obviously that is not a solution.   I assumed calculated columns were refreshed whenever the table was accessed, such as when editing, printing a report, or browsing , but perhaps not.  Can anyone help me out here?  How do I make sure that field contains the correct age?   Patrick 6.5++/7.1