I have a query_posts call in a WP template. Through the use of the More Fields Plugin I can give the site admin the ability to create an event (custom post type) and then enter a date which is formatted: YYYY/mm/dd.
The main question is; what value should I pass to the value option in the meta_query array? I am currently trying to pass "date("Y/m/d h:i A")" (minus the quotes), because, as I understand it, that will print the current date today. I don't care about the time of date so that may be irrelevant. Ulitimatly I am trying to use the compare option to nail down showing upcoming events, past events in different places on this site. In one other spot I actually need to pass the value option an array that prints that first and last day of the current month, limiting the output to events happening this month.
<?php query_posts( array( 'post_type' => 'event', // only query events 'meta_key' => 'event_date', // load up the event_date meta 'orderby' => 'meta_value', // sort by the event_date 'order' => 'asc', // ascending, so earlier events first 'posts_per_page' => '2', 'meta_query' => array( // restrict posts based on meta values 'key' => 'event_date', // which meta to query 'value' => date("Y/m/d h:i A"), // value for comparison 'compare' => '>=', // method of comparison 'type' => 'DATE' // datatype, we don't want to compare the string values ) // end meta_query array ) // end array ); // close query_posts call ?>