Hello,
I’ve a custom post type “events” with a ACF field called “date”.
I want get the next event from now , how do I have to write the query?
Best
P.
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;
?>