title: SQL Server: Return records within X days of a date
body: <p>I need a WHERE condition in SQL Server where I can return the past 7 days of activity from a given date.</p>
  
  <p>Pretend I have 2 columns of dates [dateA] and [dateB]</p>
  
  <p>I am looking for something like</p>
  
  <pre><code>SELECT *
  FROM TABLE
  WHERE [dateB] &gt;= ([dateA] - 7 days)
  </code></pre>