check for tenancy based on dates

$meta_query = array(
	'relation' => 'AND',
	array(
		'key'     => 'property_id',
		'value'   => '$paymentsArray[$key]['property_id']',
		'compare' => '=',
	),
	array(
		'key'     => 'commencement_date',
		'value'   => '$holding_fee_start_date',
		'compare' => '>',
		'type'    => 'DATE',
	),
	array(
		'key'     => 'commencement_date',
		'value'   => '$holding_fee_end_date',
		'compare' => '<',
		'type'    => 'DATE',
	),
);