Perform query with meta_value date

2 Views

I am trying to perform a query on a custom-type post using the value of a custom field.
This field contains a string date: dd.mm.yyyy.
The post type name is ‘event’
The custom field name is ‘date_event’

I would like to show all the EVENT that have the month of DATE_EVENT matching with the current month.

Read More

Any suggestion pls?

Post Views: 2

Related posts

1 comment

  1. I did something similar, the technique you need to use is called a meta query.

    Here is the query I wrote to get posts based on a date value stored as a custom field meta value. 

    query_posts(
array(
'post_type'=>'post',
'order'=>'ASC',
'orderby'=>'meta_value_num',
'meta_key'=>'date_event',
'posts_per_page'=> -1,
'meta_query' => array(
    'relation' => 'AND',
       array(
           'key' => 'date_event',
           'value' => $startDate, // Lowest date value
           'compare' => '>='
       ),
       array(
           'key' => 'date_event',
           'value' => $endDate, // Highest date value
           'compare' => '<='
       )
   )
));

    'orderby' => 'meta_value_num' will sort the results by the meta value

    'meta_key' => 'date_event' tells what the custom field is called

    meta_query is an array which specifies that the results must match both conditions, then we specify a minimum date and a maximum date.

    The date values must be stored either as YYYY-MM-DD or as a “Seconds since the Unix Epoch” value.

Comments are closed.