I have dates stored in the format d-m-Y, and i want to display any posts that are in the past, before today.

    $args = array (
        'post_type'=>'property',
        'post_status'=>'publish',
        'posts_per_page'=> 8,
        'paged'=> $paged,
        'meta_query' => array(
            'key' => 'auction_date',
            'value' => date( 'd-m-Y'),
            'compare' => '<',
            'type' => 'DATE'
        ),
      );

This doesn't seem to work and i can't figure out why. Any suggestions would be much appreciated.

I have dates stored in the format d-m-Y, and i want to display any posts that are in the past, before today.

    $args = array (
        'post_type'=>'property',
        'post_status'=>'publish',
        'posts_per_page'=> 8,
        'paged'=> $paged,
        'meta_query' => array(
            'key' => 'auction_date',
            'value' => date( 'd-m-Y'),
            'compare' => '<',
            'type' => 'DATE'
        ),
      );

This doesn't seem to work and i can't figure out why. Any suggestions would be much appreciated.

• wp-query
• custom-field
• meta-query
• date

Share Improve this question asked Jan 30, 2020 at 11:12 reigns1989reigns1989 1711 silver badge66 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

ACF stores it's dates in Ymd format, this is why i couldn't compare.

Make sure your date is in Ymd format when you compare it against an ACF datefield.