Reply To: ACF Relationship multiple meta query

• gleenk

• November 6, 2017 at 10:43 pm

It doesn’t work. I searched online, used Ymd or Y-m-d format but nothing to do:

$eventi = get_posts(array(
                'post_type' => 'eventi',
                'posts_per_page'   => -1,
                'meta_key' => 'eve_start_date', //setting the meta_key which will be used to order
                'orderby' => 'meta_value', //if the meta_key (population) is numeric use meta_value_num instead
                'order' => 'ASC',
                'meta_query' => array(
                    'relation'  => 'AND',
                    array(
                        'key' => 'correla_evento_a_struttura', // name of custom field
                        'value' => '"' . get_the_ID() . '"', // matches exaclty "123", not just 123. This prevents a match for "1234"
                        'compare' => 'LIKE'
                    ),
                    array(
                        'meta_key'     => 'eve_start_date',
                        'type'         => 'DATETIME',  // You can also try changing it to TIME or DATE if it doesn't work
                        'meta_value'   => current_time("Ymd"),
                        'meta_compare' => '>='
                    ),
                ),

            ));