EntityFieldQuery with date field I am running the following code, retrieving a list of job openings that will expire in 7 days. 

$triggerDate = new DateTime();
$triggerDate-&gt;add(new DateInterval("P7D"));

$query = new EntityFieldQuery();
$query-&gt;entityCondition('entity_type','node')
  -&gt;entityCondition('bundle','job')
  -&gt;propertyCondition('status',1)
  -&gt;fieldCondition('field_expires','value',$triggerDate-&gt;format('Y-m-d'),'=');


This is returning 0 jobs, even though I have several that will expire in 7 days.  For example, one of my job nodes, has the following value

[field_expires] =&gt; Array
     (
         [und] =&gt; Array
             (
                 [0] =&gt; Array
                     (
                         [value] =&gt; 2013-05-09T00:00:00
                         [timezone] =&gt; America/Los_Angeles
                         [timezone_db] =&gt; America/Los_Angeles
                         [date_type] =&gt; date
                     )

             )

     )


When I leave the filter off altogether, the query succeeds and retrieves all items.  I've tried many variations of the date format including Y-m-d\T00:00:00 and Y-m-d 00:00:00.  

The field is of type: Date (ISO format).  What am I doing wrong?
This works perfectly fine:

$query = new EntityFieldQuery();
$result = $query-&gt;entityCondition('entity_type','node')
  -&gt;entityCondition('bundle', 'product_display')
  -&gt;propertyCondition('status', 1)
  -&gt;fieldCondition('field_expires','value', '2013-04-30T14:02Z', '&gt;')
  -&gt;execute();