title: Last 5 weeks prior to the last week in SQL
body: <p>I want to take the last 5 weeks prior to the week before the current week. Today is Oct 4, 2017 so I want date range to be between Aug 21-Sep 24. This is the code I'm using, but it doesn't work for some reason:</p>
  
  <pre><code>DATEADD(week, -5, GETDATE()) and DATEADD(week, -1, GETDATE())
  </code></pre>
  
  <p>I also tried <code>DATEADD(week, -6, GETDATE()) and DATEADD(week, -2, GETDATE())</code> but no change happens, so weird.</p>
  
  <p>Can anyone help me please. It's sql query in SQL 2012.</p>
  
  <pre><code>WHERE hire_date between DATEADD(week, -6, GETDATE()) and DATEADD(week, -2, GETDATE())
  </code></pre>