title: Google Sheets QUERY 'where' condition returning empty output when trying to select by date
body: <p>I am learning Google Sheets functions/formulas, and am running into an issue with the QUERY function. I have two separate sheets, and am trying to pull rows/columns from one sheet into the other. Sheet B is where I want to pull the data from. Sheet B has 5 columns, A through E. Rows are added and deleted to this sheet, so the number of rows being queried will vary. I want to pull all rows where column E equals today's date. Here is the code I'm trying:</p>
  
  <pre><code>=query('SheetB'!A5:E100, "SELECT A,B,D,E where E = '" &amp;TODAY()&amp; "'")
  </code></pre>
  
  <p>Column E is formatted as such: MM/DD/YY</p>
  
  <p>This returns "#N/A", or "Query completed with an empty output"</p>
  
  <p>If I run the above code without the where condition, it returns data as expected. I have no idea why, or what the problem is. Any guidance will be greatly appreciated.</p>