Forum Discussion
ArchiveUser
8 years agoQrew Captain
Forgot to give you the formula I used in the 0-11 age range field:
var date DOB = [Date of Birth];
var number AGE =
Year(Today())-Year($DOB)
-
If(Month(Today())<Month($DOB)
or
(Month(Today())=Month($DOB) and Day(Today())<Day($DOB)),1,0);
If(IsNull($DOB), "Missing D.O.B.",$AGE <=11, "0-11")