Get posts with date on or after current date

• pdkaizer

• April 29, 2014 at 5:47 am

I have a post category called events where I some custom fields. One is call event_date and it uses the Date.time piker ACF plugin. I want to retrieve post based on that even_date field when the event_date is on or after the current date.

I have this:

<?php
    $args = array(
       'meta_key' => 'event_date',
       'orderby' => 'meta_value',
       'order' => 'ASC',
       'cat' => '2'
    );

    $the_query = new WP_Query( $args );
    
    
    if ( $the_query->have_posts() ) {
        while ( $the_query->have_posts() ) {
            
            $the_query->the_post(); ?>

            <div class="home-post-area">

                <div class="home-post-image">
                    <?php the_post_thumbnail('', array('class' => 'img-responsive')); ?>
                  <div class="home-post-image-overlay">
                    <h3><a href="<?php the_permalink() ?>"><?php the_field('event_date'); ?> <?php the_field('event_price'); ?></a></h3>
                    <h4><a href="<?php the_permalink() ?>"><?php the_title();?></a></h4>
                  </div>
                </div>

                <div class="home-post-content">
                    <?php the_excerpt();?>

                <p><a href="<?php the_permalink() ?>"><strong>>> MORE</strong></a></p>

                </div>

            </div>

        <?php } } else { ?>

        <h2>Not Found</h2>

    <?php //endif; ?>
    <?php } ?>
    <?php wp_reset_postdata(); ?>

and it gets the vents and sorts them correctly by the event_date field but I need to know how I add the additional condition of the event_date being equal to or greater than the current date. Any assistant would be appreciated. Thanks!

• enorog

• May 4, 2014 at 6:31 pm

Hi,

you need to specify your first meta_query in more detail.

$today = date('Ymd');
$args = array (
    'post_type' => 'events',
    'order' => 'ASC',
    'cat' => '2',
    'meta_query' => array(
	     array(
	        'key'		=> 'event_date',
	        'compare'	=> '>=',
	        'value'		=> $today,
	    )
    ),
);

This is an approximation of the code based on what I can gather from your example. The important part is just to add the ‘meta_query’ in your standard query and you’ll be set.