Show future events based on custom field AND order by date

I found the actual issue so I thought I’d update.

ACF documentation says to use $today = date (‘Ymd’) to compare dates but you really need to use current_time(‘Ymd’) so I removed the functions.php code that I added and fixed the problem rather than work around it.

Here’s my query now

$event1 = current_time('Ymd');
    $args = array(
        'post_type' => 'events',
    'post_status' => 'publish',
    'posts_per_page' => '10',
    'meta_query' => array(
        array(
            'key' => 'event_date_ends',
            'compare' => '>=',
            'value' => $event1,
            )
            ),
    'meta_key' => 'event_date_ends',
    'orderby' => 'meta_value',
    'order' => 'ASC',
    'paged' => ( get_query_var('paged') ? get_query_var('paged') : 1 ),
);

So for your query try this

$today = current_time('d M, y');

$args = array (
    'post_type'              => 'event',
    'meta_query'             => array(
        array(
            'key'       => 'date',
            'value'     => $today,
            'compare'   => '>=',
        ),
    ),
    'meta_key'               => 'date',
    'orderby'                => 'meta_value',
    'order'                  => 'ASC'
);

Just make sure the current_time (‘d M, y’) is how you have your data being stored via whatever date picker you’re using or if you’re typing it in each event in a field that’s how you’re typing it in. d M, y would read 19 Jun, 14. Remember your display date and stored date can read differently. I hope this helps.

Related Posts: