title: Google Sheets query date > today()
body: <p>I'm trying to filter out dates greater than today. I looked up the syntax but the date-part does not work; I'm still getting dates > today in the results.
  Could someone help me out with this?! Thank you! Here' the query:</p>
  
  <pre><code>=iferror(sort(if(isblank(Sheet1!B1),
  query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1TWDHeriSlgHYKYmfwNxVm_4apbuavrX94itSpEykBI4/edit#gid=1635810036","responses!b2:l"),"select *"),query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1TWDHeriSlgHYKYmfwNxVm_4apbuavrX94itSpEykBI4/edit#gid=1635810036","responses!b2:l"),
  "select * WHERE Col1 = '"&amp;Sheet1!$B$1&amp;"'AND Col2 &gt; date'"&amp;TEXT(today(),"dd-mm-yyyy")&amp;"'")),2,true),"no results")
  </code></pre>