HowTo influence what is selectable in an exposed date filter in views?

Here's how I did it.

In template.php:

function THEME_NAME_preprocess_date_views_filter_form(&$vars) {
  $form = $vars['form'];

  // query to select valid years where "event" is the content type we are filtering in the view
  // this query could be very different, depending on what date field you are actually querying
  $result = db_query("SELECT DISTINCT
          year(node_data_field_date.field_date_value) AS node_data_field_date_field_date_value
          FROM node node
          LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid
          WHERE (node.status <> 0) AND (node.type in ('event'))
          group by node_data_field_date_field_date_value
          order by node_data_field_date_field_date_value");

  $options = array();

  // "year" is the name of the year select in the form
  $options[] = array_shift($form['value']['year']['#options']);
  while ($year = db_fetch_object($result)) {
    $yval = $year->node_data_field_date_field_date_value;
    $options[$yval] = $yval;
  }
  // replace the default options with our new options array
  $form['value']['year']['#options'] = $options;

  // re-render the form
  $vars['description'] = drupal_render($form['description']) . drupal_render($form);

}

Replace THEME_NAME with your actual theme name.

If there's a better way to do this, I would love to know what it is.

hi, you can do it like that:

--- snip ---
  $options = array('' => '-Jahr');
  // "year" is the name of the year select in the form
  while ($year = db_fetch_object($result)) {
    $yval = $year->yearvalue;
    $options[$yval] = $yval;
  }
  // replace the default options with our new options array
  $form['value']['year']['#options'] = $options;
--- snap ---

There were a couple other issues about this and I already commented on them. I committed some changes to the code so the filter will pick up the year range you put in the filter settings (it looks like '-5:+10'.