Reply To: Query not running as expected

• Shoxt3r

• February 4, 2022 at 9:09 am

Ok so on review I think it must be something to do with the conditions within the query I’m running as I’ve double-checked the Return Format of the ACF and it’s set to a Custom value of “U” which should match back to my dateToday variable value.

$comingSoonFilms = new WP_Query(array(
        'post_type' => 'film',
        'posts_per_page' => -1,
        'order' => 'ASC',
        'meta_query' => array(
            array(
                'key' => 'film_releasedate',
                'value' => $dateToday,
                'type' => 'DATE',
                'compare' => '>',
            ),
            array(
                'key' => 'film_active',
                'value' => '1',
            ),
        )
    ));

As you can see from the live deployment, I’ve printed both the formatted and unformatted data for the release date. Therefore I don’t think this is related to the Advanced Custom Field itself.

Any thoughts please or things I could try to debug the issue with?