How to query posts with current or future date only

admin管理员组

文章数量:1321245

I want to only get posts with current or future dates, to show upcoming events.

Current arguments:

$args = array( 
    'post_type' => 'event', 
    'meta_key'  => 'event_start_date',
    'orderby'   => 'meta_value',
    'order'     => 'ASC'
);

This returns all the posts, including past events.

I read about post_status but it did not seem to work. I tried 'post_status' => 'future' without success.

I want to only get posts with current or future dates, to show upcoming events.

Current arguments:

$args = array( 
    'post_type' => 'event', 
    'meta_key'  => 'event_start_date',
    'orderby'   => 'meta_value',
    'order'     => 'ASC'
);

This returns all the posts, including past events.

I read about post_status but it did not seem to work. I tried 'post_status' => 'future' without success.

• posts
• wp-query

Share Improve this question edited Oct 30, 2014 at 16:37 Gabriel 2,2481010 gold badges2222 silver badges2424 bronze badges asked Oct 30, 2014 at 15:35 ChrizleeChrizlee 7111 silver badge44 bronze badges 3

• How is your event_start_date stored (YYYY-MMM-DD, int, ...)? Have a look at the WP_Query docs on Custom Field Parameters. – Pat J Commented Oct 30, 2014 at 16:46
• It was a premade thing, it is stored as a longtext type. the actual date is stored like this: 2014-11-14 20:00 – Chrizlee Commented Oct 30, 2014 at 17:47
• 1 Longtext or not, what is the format of the date string? See the first part of the following answer: wordpress.stackexchange/a/124163/21376 – s_ha_dum Commented Oct 30, 2014 at 17:49

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 4

adding the following arguments did the trick

'meta_value' => date('Y-m-d h:i'),
      'meta_compare' => '>',

Adding 'post_status' => array('publish', 'future') to your $args will show only future published posts.

$args = array(
    'post_type'   => 'event', 
    'meta_key'    => 'event_start_date',
    'orderby'     => 'meta_value',
    'order'       => 'ASC',
    'post_status' => array('publish', 'future')
    );
get_posts( $args );

本文标签： How to query posts with current or future date only