title: Subtract 1 from current date/counting from yesterdays date
body: <p>I would like to include data 30 days back starting from yesterday. I've tried several ways but the syntax is not agreeing with me. I'm using BigQuery. </p>
  
  <pre><code>WHERE DATE(created_at) &gt; DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
  </code></pre>