Display upcoming events (including today's event)?

Question

I have the following loop that does not work. I want to show only upcoming events, including events that occur today.

At the moment, it shows all upcoming messages, as well as messages until today.

Where am I going wrong?

<?php $today = date('Ymd'); $portfolioloop = new WP_Query( array( 'post__not_in' => array(4269), 'paged' => get_query_var('paged'), 'meta_key' => the_date(), 'post_status' => 'future,publish', 'post_type' => 'whatson', 'exclude' => '4269', 'posts_per_page' => 20, 'order' => 'ASC', 'meta_query' => array( array('key' => the_date(), 'value' => $today, 'compare' => '>=') ), )); ?> <?php while ( $portfolioloop->have_posts() ) : $portfolioloop->the_post(); ?> // content here. <?php endwhile; // end of the loop. ?> 

---

I will give this:

 // Create a new filtering function that will add our where clause to the query function filter_where( $where = '' ) { $today = date('Ymd'); $where .= " AND post_date >= '$today' "; return $where; } add_filter( 'posts_where', 'filter_where' ); $query = new WP_Query( $query_string ); remove_filter( 'posts_where', 'filter_where' ); <?php $query = new WP_Query( array( 'post__not_in' => array(4269), 'paged' => get_query_var('paged'), 'post_type' => 'whatson', 'exclude' => '4269', 'posts_per_page' => 20, 'order' => 'ASC' )); ?> 

Answer 1

I think this might work:

 <?php function filter_where( $where = '' ) { $where .= " AND post_date >= '" . date("Ymd") . "'"; return $where; } add_filter( 'posts_where', 'filter_where' ); $query = new WP_Query( array( 'post__not_in' => array(4269), 'paged' => get_query_var('paged'), 'post_type' => 'whatson', 'exclude' => '4269', 'posts_per_page' => 20, 'order' => 'ASC' ) ); remove_filter( 'posts_where', 'filter_where' ); ?>