title: Using multiple date ranges in Amazon Redshift
body: <p>I am trying to grab the following date ranges: </p>
  
  <ul>
  <li>Current date - prior 6 weeks</li>
  <li>51 weeks ago - 55  weeks ago</li>
  </ul>
  
  <p>I have the following query, but it doesn't seem to work:</p>
  
  <pre><code>OR date(date) &gt;= date(dateadd(week,-6, current_date))
  OR date(date) &gt;= date(dateadd(week,-55, current_date))
  OR date(date) &lt;= date(dateadd(week,-51, current_date))
  </code></pre>
  
  <p>Any ideas? </p>