title: Datediff GETDATE Add
body: <p>In this type of code,</p>
  
  <pre><code>AND Orders.ShipDate &gt;= DATEADD(Day, Datediff(Day,0, GetDate() -6), 0)
  </code></pre>
  
  <p>It supposed to pull records with the date 6 days ago, until today. How can I make it pull records from 7 days ago until yesterday?</p>
  
  <p>I know changing <code>-6</code> to <code>-7</code> will pull records from 7 days ago, but which variable is the end of the date span so I can change it to <code>-1</code>?</p>