EntityFieldQuery fieldCondition Date not working as expected

Question

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();

Answer 1

So it looks like the final issue I was having was the operators I was using. Had to go <= on value and >= value2. I had it the other way around before. Here is the code that worked.

$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();

Answer 2

You could also use the BETWEEN operator, like:

$fromDate = date('Y-m-d') . ' 00:00:00';
$toDate = date('Y-m-d') . ' 23:59:59';
$query = new EntityFieldQuery;
$query->entityCondition('entity_type', 'node')
      ->entityCondition('bundle', 'caregiver_db')
      ->propertyCondition('status', 1)
      ->fieldCondition('field_available_dates', 'value', array($fromDate, $toDate), 'BETWEEN');
$results = $query->execute();

Also just go for the value if it's not a start/enddate field.