title: How to have Query Pull Weekly Data
body: <p>I have a a query like so that ONLY shows data for the specific day.  But how can I modify this to show data for the previous 7 days? So when I run the query this week show data for the date range of 
  01/24/2014 - 01/30/2014 then next week shows data for 01/31/2014 - 02/06/2014</p>
  
  <pre><code>SELECT * FROM SalesInformation
  WHERE (datename(dw, getdate()) = 'Monday' AND CONVERT(VARCHAR(10), DateSold, 101) = DATEADD   (Day,DATEDIFF(Day,0,GetDate()),0))
  OR (datename(dw, getdate()) = 'Tuesday' AND CONVERT(VARCHAR(10), DateSold, 101) = DATEADD(Day,DATEDIFF(Day,0,GetDate()),0))
  OR (datename(dw, getdate()) = 'Wednesday' AND CONVERT(VARCHAR(10), DateSold, 101) = DATEADD(Day,DATEDIFF(Day,0,GetDate()),0))
  OR (datename(dw, getdate()) = 'Thursday' AND CONVERT(VARCHAR(10), DateSold, 101) = DATEADD(Day,DATEDIFF(Day,0,GetDate()),0))
  OR (datename(dw, getdate()) = 'Friday' AND CONVERT(VARCHAR(10), DateSold, 101) = DATEADD(Day,DATEDIFF(Day,0,GetDate()),0))
  </code></pre>