Support

Account

Home Forums ACF PRO wp query with multiple relation keys Reply To: wp query with multiple relation keys

  • 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)