CurrentDate - Birthdate
will calculate the person's age, but in days, not years.
Let ( [ B = YourTable::BirthDateField ;
T = Get ( CurrentDate )
Year ( T ) - Year ( B ) - ( T < Date ( Month ( B ) ; Day ( B ) ; Year ( T ) ) )
will calculate an age in years. Assuming that you put the above as the definition for an unstored calculation field named Age, your Case Function will look like:
Case ( Age < 5 ; "Peewee" ;
Age < 9 ; "Child" ;
Age < 13 ; "Junior" ;
Awesome. Will the AgeGroup field have to be any specific type (edit box, drop down, etc.)?