Reputation: 729
I need to order posts by custom meta box date field
$args = array(
'meta_key' => 'event_date',
'orderby' => 'meta_value_num',
'order' => 'ASC',
'post_status' => 'publish',
'post_type' => 'events',
'numberposts' => -1
);
$poslist= get_posts( $args );
I tried above code but its not working, date filed format is "yyyy-mm-dd"
Upvotes: 0
Views: 1369
Reputation: 729
$fromDate = '2013-01-01';
$toDate = '2014-01-01';
$args = array(
'meta_key' => 'event_date',
'orderby' => 'meta_value',
'order' => 'DESC',
'post_status' => 'publish',
'post_type' => 'page',
'numberposts' => -1,
'meta_query' => array( array(
'key' => 'event_date',
'value' => $toDate, // date to compare to, before this one
'compare' => '<',
'type' => 'DATE' //set the format
),
array(
'key' => 'event_date',
'value' => $fromDate, // date to compare to, after this one
'compare' => '>=',
'type' => 'DATE' //set the format
),
),
);
$currentEventsPost = get_posts( $args );
Upvotes: 1
Reputation: 1042
Try something along the lines of
$args = array(
'post_type' => 'events',
'meta_key' => 'event_date',
'orderby' => 'meta_value',
'order' => 'ASC',
'meta_query' => array(
array(
'key' => 'event_date',
'compare' => 'LIKE',
)
)
);
$query = new WP_Query($args);
Upvotes: 1