title: Select Query To Show Data From Friday To Thursday
body: <p>My date field that this should be based off of is <code>shipdate</code> how can I run a <code>Select</code> statement and have it return data from Friday to Thursday without hard coding in dates?</p>
  
  <p>Something like </p>
  
  <pre><code>Select * from shippinginfo where shipdate between 'Friday' and 'Thursday'
  </code></pre>
  
  <p>For a little clarity this is what I want to achieve
  The where clause should be between Friday and Thursday of the previous week. So for example this week it would be 08/28/2015 - 09/03/2015 but next week it would be 09/04/2015 - 09/10/2015</p>