Topic Tag: Views plugin

// Filter a View by date-like custom field value YYYY-MM, show only results from current year and two previous years
// https://toolset.com/forums/topic/view-which-filters-on-yyyy-mm/
add_filter( 'wpv_filter_query', 'tssupp_yyyy_mm_two_years_ago', 99, 3 );
function tssupp_yyyy_mm_two_years_ago( $query_args, $views_settings, $view_id) {
  $view_ids = array( 123 );         // your view ID or IDs
  $date_field_slug = 'field-slug';  // your date field slug
 
  // --------- you should not edit below this line ---------------------
 
  if (in_array($view_id, $view_ids)){
    $year = date('Y');
    $query_args['meta_query'] = array(
      'relation' => 'OR',
      'year1_clause' => array(
          'key' => 'wpcf-'.$date_field_slug,
          'compare' => 'LIKE',
          'type' => 'STRING',
          'value' => $year
      ),
      'year2_clause' => array(
          'key' => 'wpcf-'.$date_field_slug,
          'compare' => 'LIKE',
          'type' => 'STRING',
          'value' => ($year-1)
      ),
      'year3_clause' => array(
          'key' => 'wpcf-'.$date_field_slug,
          'compare' => 'LIKE',
          'type' => 'STRING',
          'value' => ($year-2)
      )
    );
  }
  return $query_args;
}