I'm using Calendar + Views to filter through shows, which each span a range of dates. Search options allow for content to be filtered by Year and Month, while a small calendar module on the home page allows for content to be filtered by Date. In both cases, the content will be filtered TO correctly but not FROM. So if I filter by Date, content will start at the correct date but also show content from all dates past that. Same goes for the Month view.

I've tried a variety of settings for the Filter Date node, but right now it is at:
>= FROM this month TO blank, exposed, day granularity, Content: Open to Close Date Range (field_open_date) - To date

If I do something like "is between," it filters correctly but I'm looking to show just the selected month or just the selected date. Any suggestions?

Thanks!

Here's what I have for the filters handler, if that helps:

$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'event' => 'event',
      'ta_event' => 'ta_event',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
  'date_filter_1' => array(
    'operator' => '>=',
    'value' => array(
      'min' => NULL,
      'max' => NULL,
      'value' => NULL,
      'default_date' => 'this month',
      'default_to_date' => '',
    ),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'operator' => 'date_filter_1_op',
      'label' => 'Date: Date (node)',
      'use_operator' => 0,
      'identifier' => 'date_filter_1',
      'optional' => 1,
      'remember' => 0,
    ),
    'date_fields' => array(
      'node_data_field_open_date.field_open_date_value2' => 'node_data_field_open_date.field_open_date_value2',
    ),
    'date_method' => 'AND',
    'granularity' => 'day',
    'form_type' => 'date_select',
    'default_date' => 'this month',
    'default_to_date' => '',
    'year_range' => '-10:+3',
    'id' => 'date_filter_1',
    'table' => 'node',
    'field' => 'date_filter',
    'relationship' => 'none',
  ),
  'tid' => array(
    'operator' => 'or',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'operator' => 'tid_op',
      'label' => 'Event Type',
      'use_operator' => 0,
      'identifier' => 'tid',
      'bef_filter_description' => '',
      'bef_format' => 'bef',
      'optional' => 1,
      'single' => 0,
      'remember' => 0,
      'reduce' => 0,
      'bef_select_all_none' => 0,
    ),
    'type' => 'select',
    'limit' => TRUE,
    'vid' => '2',
    'id' => 'tid',
    'table' => 'term_node',
    'field' => 'tid',
    'hierarchy' => 1,
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
    'reduce_duplicates' => 0,
  ),
  'field_producer_nid' => array(
    'operator' => 'or',
    'value' => array(),
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'field_producer_nid_op',
      'identifier' => 'field_producer_nid',
      'label' => 'Organization(s)',
      'bef_filter_description' => '',
      'bef_format' => 'default',
      'optional' => 1,
      'single' => 1,
      'remember' => 0,
      'reduce' => 0,
      'bef_select_all_none' => 0,
    ),
    'id' => 'field_producer_nid',
    'table' => 'node_data_field_producer',
    'field' => 'field_producer_nid',
    'relationship' => 'none',
    'reduce_duplicates' => 0,
  ),
  'field_venue_value' => array(
    'operator' => 'word',
    'value' => '',
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'field_venue_value_op',
      'identifier' => 'field_venue_value',
      'label' => 'Venue Keyword',
      'optional' => 1,
      'remember' => 0,
    ),
    'case' => 0,
    'id' => 'field_venue_value',
    'table' => 'node_data_field_venue',
    'field' => 'field_venue_value',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
  'title' => array(
    'operator' => 'word',
    'value' => '',
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'title_op',
      'identifier' => 'title',
      'label' => 'Title Keyword',
      'optional' => 1,
      'remember' => 0,
    ),
    'case' => 0,
    'id' => 'title',
    'table' => 'node',
    'field' => 'title',
    'relationship' => 'none',
  ),
  'status' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'status',
    'table' => 'node',
    'field' => 'status',
    'relationship' => 'none',
  ),
));

Comments

DamienMcKenna’s picture

Status: Active » Closed (won't fix)

Unfortunately the Drupal 6 version of the Date module is no longer supported. That said, we appreciate that you took time to work on this issue. Should this request still be relevant for Drupal 7 please feel free to reopen it. Thank you.