CiviCRM Community Forums (archive)

I have a website that is used by a Rugby Union Club and we run teams in various age groups.  I want to be able to produce a list of contacts who's birth date is between two dates which can be entered by the user.  I have tried the following two methods both of which use Views 2:

• Method 1
• Create Smart Groups to gather contacts in age groups
• Display the information required in a view and expose a filter which contains the group
• This method doesn't work since smart groups are not supported in Views

• Method 2
• Display the information required in a view and expose a filter which contains the field Birth Date
• This method doesn't work since the Birth Date field does not display the date handlers in Views to enable the start and end dates to be entered

In both cases I am stymied and I have not been able to determine another method. I would appreciate some suggestions to solve the problem.

Cheers
Martin Fuggle

The only other solution I could think of would be a custom-coded form in Drupal.

I agree. There is code for a Drupal 6 module which, while limited in filtering, does function http://forum.civicrm.org/index.php/topic,25479.msg107913.html#msg107913

I am going to pay for that code to be ported to Drupal 7 and perhaps tweaked somewhat to allow and / or filtering on the group IDs. Further to that there is an issue with Drupal Groups being synced into Views which results in an SQL error. I will ask the developers to attend to this issue in the Drupal / Views integration code.