Date Formats and Exposed Filters

Date formatting – the order of day, month, and year – is important to many websites. However, getting date formats working correctly with Views’ exposed filters can take a bit of administrative work.

The following modules should be installed and enabled:

• Views: Views UI (requires CTools and Views)
• (optional) Better Exposed Filters
• Date: Date (requires Date API) and Date Views

At this point, you can use the existing date fields that come by default with any content type (i.e.: created, updated, last comment, etc.) or you can add date fields to a content type. In the instructions below , text in dialogs or options to choose will be shown in bold italics.

To build a view that uses a custom date format:

1. In a newly created or existing view, add a Date: Date (node) filter

   

2. In the Configure extra settings for filter criterion dialog
1. For Date selection form element, select Text.
2. Under Date field(s), tick the fields you want included in this filter. You can set the AND/OR of the fields selected under the Method heading. For simplicity, just tick one field.

   

3. Click the Apply button
4. On the Configure filter criterion: Date: Date (node) dialog, tick the Expose this filter to visitors, to allow them to change it checkbox. Change the Label as needed.

   

5. Click the Apply button.
3. To adjust the date format, go to the Date and time admin page (admin/config/regional/date-time), adjust the Short date format to use the date order you want. (e.g.: Year-Month-Day)
1. You can use the Filter granularity in the Configure extra settings for filter criterion Date: Date (node) dialog to include adjust the resolution of the filer. For example, leave just Year and Month ticked to filter by all posts created in a given month.
2. If you enable to Better Exposed Filters module, you can set a jQuery UI Datepicker widget for your exposed date filter fields. Note that the datepicker currently has problems with granularities that include hours, minutes, and seconds.

   

   And the resulting page: