Custom wordpress meta query (no result)

Question

Problem

I am looping through custom post types (Advanced Custom Fields) in Wordpress. I only want to display events with start_date equal to $newdate variable, defined in the beginning.

The start_date is in the format YYYY-MM-DD HH:mm (the same as $newdate). $newdate is set to the beginning of the day so I wouldn't exclude events with different hours in the day and compare is set to greater than (just to test the query).

However I am not getting any results.

<?php
$newdate = date('Y-m-d 00:00');
//<-- Start the Loop. -->!
$args = array( 
        'post_type' => 'epsa_events', 
        'posts_per_page' => 5,
        'orderby' => 'meta_value',
        'order' => 'ASC',
        'meta_query' => array (
            array(
            'key' => 'start_time',
            'value'   => $newdate,
            'compare' => '>=',
            'type' => 'datetime' 
            )
        )
    );

$loop = new WP_Query( $args );

if your start_time is in that format then it is not datetime but varchar.So you compare 2 string with uncontrollable results. — Mihai, Jan 03 '16 at 16:43

Ravi Hirani · Answer 1 · 2016-01-03T16:35:50.723

0

Try this query:-

'meta_key'   =>  'event-start-date',
'meta_query' => array (
            array(
            'key' => 'start_time',
            'value' => date('Ymd',strtotime($newdate)),
            'compare' => '>=',
            'type' => 'date' 
            )
        )

edited Jan 03 '16 at 16:35

answered Jan 03 '16 at 16:02

Ravi Hirani

6,511
1
27
42

Stull no results with this change. – rmilosic Jan 03 '16 at 16:13
change type datetime to date – Ravi Hirani Jan 03 '16 at 16:34
Did you ever get this working, im trying to filter datetime by a range of hours as well, but not having any luck @rmilosic – Nickey K May 27 '20 at 11:55
@NickeyK sorry, It was quite a long time ago and I can't seem to find the source code unfortunately :/ – rmilosic May 27 '20 at 17:13

score 0 · Answer 2 · answered Jul 14 '16 at 11:49

I guess you have some small mistakes here.

First, if you use 'orderby' => 'meta_value' you must add a 'meta_key' => KEYVALUE to your $args where KEYVALUE is the name of the custom field you want to use for sorting. Check WP_Query documentation on Order & Orderby Parameters.

Second, assuming your start_date field type is Date Time Picker, if you want to get all events that already started you're using the wrong comparison operator. So assuming you also want to sort by date, your $args code should be:

$args = array(
    'post_type'      => 'epsa_events',
    'posts_per_page' => -1,
    'orderby'        => 'meta_value',
    'order'          => 'ASC',
    'meta_key'       => 'start_time',
    'meta_type'      => 'DATETIME'
    'meta_query'     => array (
        array(
            'key'     => 'start_time',
            'compare' => '<=',
            'value'   => $newdate,
            'type'    => 'DATETIME'
        )
    )
);

Take a look at Date Time Picker documentation too.

I hope this helps!

Custom wordpress meta query (no result)

2 Answers2