title: BigQuery SQL WHERE Date Between Current Date and -15 Days
body: <p>I am trying to code the following condition in the <code>WHERE</code> clause of SQL in BigQuery, but I am having difficulty with the syntax, specifically <em>date</em> math:</p>
  
  <pre><code>WHERE date_column between current_date() and current_date() - 15 days
  </code></pre>
  
  <p>This seems easy in MySQL, but I can't get it to work with BigQuery SQL.</p>