Deeban Babu
Deeban Babu

Reputation: 729

Order by custom metabox value for date in get_posts

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

Answers (2)

Deeban Babu
Deeban Babu

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

Richard Denton
Richard Denton

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

Related Questions