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.

Any suggestion pls?

  • 1
    show what you have tried. the first step is to reverse the order of the dates you're storing to be in MySQL date format - yyyy-mm-dd
    – Milo
    Commented May 7, 2013 at 21:09
  • you mean that the value must not be a string but a MySql date? Commented May 7, 2013 at 21:14
  • a string, but the units should be in descending order from large to small- year, month, day. if you think of the dates as just one big number, and then adding, subtracting, comparing them, it makes sense why it should be in that order.
    – Milo
    Commented May 7, 2013 at 21:25
  • ok, done. but now how can i use this value to perform my query? Commented May 7, 2013 at 21:28
  • 1
    Can you show your current code?
    – vancoder
    Commented May 7, 2013 at 21:46

1 Answer 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.

'posts_per_page'=> -1,
'meta_query' => array(
    'relation' => 'AND',
           'key' => 'date_event',
           'value' => $startDate, // Lowest date value
           'compare' => '>='
           '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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.