Reply To: wp query with multiple relation keys

• John Huebner

• October 26, 2018 at 10:54 pm

The first thing that I notice is your start/end date fields

                        array(
                            'key'   => 'period_a_start',
                            'compare' => '>=',
                            'type' => 'numeric',
                            'value' => date("Ymd", strtotime($datefrom)),

                        ),
                        array(
                            'key'   => 'period_a_end',
                            'compare' => '<=',
                            'type' => 'numeric',
                            'value' => date("Ymd", strtotime($dateto)),

                        ),

I think you have >= and <= reversed here. For start date the you want to see if start date (value in db) <= value (input date)