Reply To: Query posts where end and/or start date are in the past

• John Huebner

• January 8, 2016 at 11:07 am

I’m not sure how to fix that. You might try setting the ‘meta_key’ query argument to the start date field name, but I don’t know it that will work

$wp_query = new WP_Query( array(
  'post_type'    => 'event',
  'meta_query'   => array(
    'relation'      => 'OR',
    // if start date and end date are < now
    // OR
    // if start date < now and end date is empty
    array(
      'relation'    => 'AND',
      // if start date < now and end date is emptye
      array(
        'key'         => 'acf_event_date_start',
        'value'       => date('Ymd'),
        'compare'     => '<',
        'type'        => 'date'
      ),
      array(
        'key'         => 'acf_event_date_end',
        'value'       => '',
        'compare'     => '='
      )
    ),
    array(
      'relation' => 'AND',
      // if start date and end date < now
      array(
        'key'         => 'acf_event_date_start',
        'value'       => date('Ymd'),
        'compare'     => '<',
        'type'        => 'date'
      ),
      array(
        'key'         => 'acf_event_date_end',
        'value'       => date('Ymd'),
        'compare'     => '<',
        'type'        => 'date'
      )
    )
  ),
  'meta_key'    => 'acf_event_date_start',
  'orderby'     => 'meta_value_num',
  'order'       => 'DESC',
  'paged'       => $paged
));