My database is used for student demographics and other needed data collection for reports. At the beginning of the school year I was able to get help regarding the AGE field from this forum. The formula that was given to me to automatically calculate the age when the DOB was input was grateful [color:"brown"] . Now I have run into the issue of keeping that AGE updated. Is there a way I can do this? The formula I used is: Year(Status(CurrentDate)) - Year(Date of Birth) - (Status(CurrentDate) < Date(Month(Date of Birth), Day(Date of Birth), Year(Status(CurrentDate))))
I would surely appreciate any suggestions!!!
