Here's the ranges:
55 and over. That's a total of seven age categories. I missed the last one in the original count.
I am getting the formula to work somewhat. when I test it, I am getting incorrect results. I have tested the formula so far by:
Any suggestions on how to fix? If making the field return just a '1' if the record is within the age range or a null or 0 if the record is in the age range is easier, that would be great as I need to just count those records in each age range anyhow.
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")