I've searched WP Codex and StackExchange and gotten some clues, but I can't get this query working. I have 2 custom fields associated with each exhibition in Y-m-d format: exstart-date being the start date of the exhibition and exend-date being the ending date.
I can easily display upcoming exhibits and past exhibits, but I cannot get the meta_query right to display current exhibits (with a start date less than or equal to today AND end date greater than or equal to today). The code below displays nothing on the page. Help?
$paged = ( get_query_var('paged') ) ? get_query_var('paged') : 1; $today = date('Y-m-d', strtotime('-6 hours')); query_posts(array( 'post_type' => 'exhibitions', 'posts_per_page' => 6, 'paged' => $paged, 'orderby' => 'title', 'order' => 'DESC', 'meta_query'=>array( 'relation'=>'AND', array( 'key' => 'exstart-date', 'value' => $today, 'compare' => '<=', 'type' => 'CHAR' ), array( 'key' => 'exend-date', 'value' => $today, 'compare' => '>=', 'type' => 'CHAR' ) ) )); if (have_posts()) : while (have_posts()) : the_post();