title: QUERY current month in google spreadsheet
body: <p>Quite simple question:
  I want a query that filters the current month, I got this one working:</p>
  
  <pre><code>=query(Sheet1!A9:F; "select sum(D) where A &gt;= date '2016-10-01' and A &lt; date '2016-11-01'"; 0)
  </code></pre>
  
  <p>I need to get sth like </p>
  
  <pre><code>(...) where A &gt;= "'Year(Today())'-'Month(Today())'-01" (...)
  </code></pre>
  
  <p>but that doesn't work.
  :/</p>