EntityFieldQuery fieldCondition Date not working as expected
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();