CiviCRM Community Forums (archive)

I am using CiviCRM to (amongst many things) manage students in a nonprofit performing arts education program. We are just about to start an alumnae association for girls who have graduated from our program.

To be eligible to be in the alumnae association, an individual contact must meet two criteria:

1. The contact must have held an active membership in our program at any time in the past.
2. The contact must be at least 17 years of age.

I have been trying to create a query and smart group to automatically select girls who meet these criteria as of the date on which the query is run. I know the Advanced Search today allows me to satisfy condition 1 above, but I don't know how to satisfy condition 2.

I've poked around inside CRM/Contact/Form/Search/Criteria.php, and I can see where the age range of birth dates is queried. But I don't know how to go about implementing this addition.

I'm up for coding this myself, but I just don't have the familiarity with the architecture to know where to begin.

Any pointers would be greatly appreciated ...