how to create views with month and day in contextual filter Let suppose I have  actor content type, it has a birthday field (it is date ),
I want get all actor that has equal month and day of birth,I want to create a views with
birthsearch/%/%  path, and then I want pass  month and day to it ,
as exapmle birthsearch/02/25 , it should return all actor that birthday is 25 feb,I think contextual filter is good idea to achieve this but, by default drupal Granularity of date field  is 


  


it is means I can restrict it to year and month, but I cant restrict it to day and month,

my question is how can I have views with month and day in contextual filter (passed to it by page Url)?
I achieve this with below solution,
create birthday field filter in views and set it to something fix =2000-02-02(not important later it will bypass),
then in my custom module  I implement hook_views_query_alter and change condition to what I want  "DATE_FORMAT(field_data_field_birth_date.field_birth_date_value, '%m%d') = :field_data_field_birth_date_field_birth_date_value"; and work correctly,and views page path is sbirthdaymd/% ( as example link will be something like sbirthdaymd/0524 )

/**
 * Implements hook_views_api().
 */
function mymodule_views_api() {
  return array(
    'api' =&gt; 3,
    'path' =&gt; drupal_get_path('module', 'mymodule'),
  );
}

/**
 * Implementation of hook_views_query_alter
 * @param $view
 * @param $query
 */
function mymodule_views_query_alter(&amp;$view, &amp;$query) {
    if($view-&gt;name == 'search_cast_by_birth_and_death') {
//        ym($view-&gt;query,'message');
        $url = parse_url(current_path());
        $temp = explode('/', $url['path']);
         if(!intval($temp[1]))
             $temp[1]="0406";
        if($view-&gt;current_display=='page_2'){
        $view-&gt;query-&gt;where[1]['conditions'][2]['field']="DATE_FORMAT(field_data_field_birth_date.field_birth_date_value, '%m%d') = :field_data_field_birth_date_field_birth_date_value";
        $view-&gt;query-&gt;where[1]['conditions'][2]['value'][':field_data_field_birth_date_field_birth_date_value']=$temp[1];
        }

     }
    }