No matter what i try i cant get EntityFieldQuery to work i have a date and i need to check if it is between the start date and end date of a date field that is set to unlimited values.. it should be at least between any one.. here is what i got.. can anybody help me?
UPDATE 10/26/2016: So from what I found doing some more googling to do what I want I need to use delta_group so I added it to the code below but it doesn't seem to be working. Anybody have any idea what I'm doing wrong?
$myDate = date('Y-m-d H:i:s');
$query = new EntityFieldQuery;
$query->entityCondition('entity_type', 'node')
->entityCondition('bundle', 'caregiver_db')
->propertyCondition('status', 1)
->fieldCondition('field_available_dates', 'value', $myDate, '>=', 0)
->fieldCondition('field_available_dates', 'value2', $myDate, '<=', 0);
$results = $query->execute();