Author Topic: Filtering date by month (only) in a report or view, how? (Read 1694 times)

CiviTeacher.com · March 28, 2012, 11:50:37 am

I have a situation where I need an exposed date filter for a Drupal view or CiviCRM report that filters only by Month.

The point of this is to show date data (a custom date field called 'anniversary') that fall in a given month, regardless of if the date is on the 1st or the 29th, or year 1951 or year 1991.

The client would select from a dropdown "April" and the result would be everyone with a date in April, see what I mean?

I have noticed this is not available in the standard Drupal view filters that I can see. Nor is it a civiCRM date field filter in reports.

Any ideas for best practices or starting points?

Any ideas for modules or code?

Hershel · March 29, 2012, 10:09:49 am

I could suggest two potential approaches.

First is to use the built in date range exposed filter in Views and then use jQuery (from your theme or a module) to hide the controls and replace them with a dropdown of months. Then when that control is changed, the jQuery would update the date range controls with the corresponding values.

Second idea is to use a custom module, then you can have whatever filters you want because it's all custom.

CiviCRM Community Forums (archive)

News:

Author Topic: Filtering date by month (only) in a report or view, how? (Read 1694 times)

CiviTeacher.com

Filtering date by month (only) in a report or view, how?

Hershel

Re: Filtering date by month (only) in a report or view, how?