EntityFieldQuery fieldCondition Date not working as expected 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-&gt;entityCondition('entity_type', 'node')
          -&gt;entityCondition('bundle', 'caregiver_db')
          -&gt;propertyCondition('status', 1)
          -&gt;fieldCondition('field_available_dates', 'value', $myDate, '&gt;=', 0)
          -&gt;fieldCondition('field_available_dates', 'value2', $myDate, '&lt;=', 0);

    $results = $query-&gt;execute();
So it looks like the final issue I was having was the operators I was using. Had to go &lt;= 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-&gt;entityCondition('entity_type', 'node')
      -&gt;entityCondition('bundle', 'caregiver_db')
      -&gt;propertyCondition('status', 1)
      -&gt;fieldCondition('field_available_dates', 'value', $myDate, '&lt;=', 0)
      -&gt;fieldCondition('field_available_dates', 'value2', $myDate, '&gt;=', 0);

$results = $query-&gt;execute();