wordpress - Using ACF date picker to only show posts after today's date -

i using advanced custom fields create post-type called 'events', , jquery date picker select date of event. have posts ordered event date, started earliest date latest, want past dates not show in query.

here code:

            <?              if ( get_query_var('paged') ) {               $paged = get_query_var('paged');               } else if ( get_query_var('page') ) {                       $paged = get_query_var('page');               } else {                       $paged = 1;               }               query_posts( array( 'post_type' => 'events', 'meta_key' => 'event_date', 'orderby' => 'meta_value_num', 'posts_per_page' => 4, 'order' => 'asc', 'paged' => $paged ) );               while (have_posts()) : the_post();             ?> 

so basically, if event date past current date, don't want post show anymore.

any tips?

i'd go custom query:

global $wpdb; $items_per_page = 10; $offset = 0;         $query = "             select                 posts.*,                 date(postmeta.meta_value)             " . $wpdb->prefix . "posts posts             right join " . $wpdb->prefix . "postmeta postmeta on (postmeta.post_id = posts.id)                             posts.post_type = 'events' ,                 postmeta.meta_key = 'event_date' ,                 postmeta.meta_value > '" . date('y-m-d h:i:00') . "'             order postmeta.meta_value asc             limit " . $offset . ", " . $items_per_page . "         ";  $events = $wpdb->get_results($query);      foreach ($events $event): setup_postdata($event);               //event loop      endforeach; wp_reset_postdata(); 

where date('y-m-d h:i:00') current date format