Reply To: Get post with the next date (ACF field) from now

• Matthew McVickar

• February 20, 2015 at 4:58 am

You’ll want to query the database using the custom field’s name as a meta key and comparing the values against your current custom field’s value. Try this:

<?php

$current_event_date = get_field('date');

$next_event_query = new WP_Query(array(
  'post_type'      => 'event',
  'post_status'    => 'publish',
  'posts_per_page' => -1,
  'meta_query'     => array(
    array(
      'key'        => 'date',
      'compare'    => '>',
      'value'      => $current_event_date,
      'type'       => 'DATE'
    )
  ),
  'orderby'        => 'meta_value_num',
  'order'          => 'ASC'
));

if ($next_event_query->have_posts()) while ($next_event_query->have_posts()): $next_event_query->the_post();

  // Print information about next event.

endwhile;

?>