title: Get the date of Sunday and Saturday 2 weeks ago
body: <p>I have a stored procedure that produces a report each night. This SP references a view that takes a snapshot of data from 2 weeks ago (Sunday to Saturday).</p>
  
  <p>I need to get the dates of the Saturday and Sunday from two weeks ago (so for today that would be 23/24 of December.</p>
  
  <p>I have searched through many solutions but I am unable to find a decent response to this - any one able to help with an answer as well as explaining a little bit of the reason for doing it that way (it seems like there are a thousand ways to do it).</p>
  
  <p>Thanks</p>