CiviCRM Community Forums (archive)

How do I create a smart group based on age? eg everyone below 21 years old.

I currently have a Date of birth field, but creating a search based on that doesn't work as the people with age less than 21 is going to be based on a different DOB every year.

2 other customizations that might be even more useful to contribute back:

1) Add "age" as a param in advanced search (basically a calculated field)
2) (more generalized) Add relative date filters to search builder.

As above this would all require some coding experience, but would be of great benefit to the community.

Yes. CRMDOC is the most up-to-date but the others are probably useful too.

Hi Petednz,

My members span a wide range of ages, from the young to the old.

Inside my club, we have events targeted at the various age groups.

There's a under 12 year old group, as well as a youth group, among others.

We call them sub-groups.

The purpose of identifying these people is for us to send out emails only to the group.

I'm looking for a custom search so I can create smart groups as well based on age and gender. I found this on the CRMDOC site:https://wiki.civicrm.org/confluence/display/CRMDOC/Search+on+Gender+and+Age   however it gives the error:


Fatal error: Declaration of CRM_Contact_Form_Search_Custom_AgeGenderListing::all() must be compatible with that of CRM_Contact_Form_Search_Interface::all() in /mysite/CRM/Contact/Form/Search/Custom/AgeGenderListing.php on line 38

I've compared the AgeGenderListing.php with a newer custom search and could not figure out why it was giving the error. I made some changes but couldn't figure it out. Anyone happen to have this working?

That created a new error on line 74. I figured that one out by looking at another search. I had to update the gender code to use the new way of referring to a Psuedoconstant.
Replace this:
        $gender = array('' => ts('- any gender -')) + CRM_Core_PseudoConstant::gender( );
        foreach ($gender as $key => $var) {
                $genderOptions[$key] = HTML_QuickForm::createElement('radio', null, ts('Gender'), $var, $key);
            }
With this starting on line 74
    $genderOptions = array();
    $gender = CRM_Core_PseudoConstant::get('CRM_Contact_DAO_Contact', 'gender_id');
    foreach ($gender as $key => $var) {
      $genderOptions[$key] = $form->createElement('radio', NULL,
        ts('Gender'), $var, $key,
        array('id' => "civicrm_gender_{$var}_{$key}")
      );
    }
I updated the CRMDOC with the changes.

No, I didn't.

I change the smart groups criteria every year.

I was wondering if you ever created the search based on age extension / custom search?

The problem is, I'm not programmer.  Will also need to invest time to learn the coding. 

I wonder how many years will pass before it would have saved you time to write the code