title: How do I find last weeks dates Monday to Friday using SQL Server?
body: <p>I'd like to find last weeks dates</p>
  
  <pre><code>SELECT *
  FROM Table
  Where [Date] Between '04-Jan-2016' AND '15-Jan-2016'
  </code></pre>
  
  <p>Every time I run my SQL Query it needs to display <code>last week</code>.</p>