title: SQL DATEADD Function for 7 days after the end of the last quarter
body: <p>MS SQL Server: I'm trying to get 7 days after the end of the last quarter...</p>
  <p>Here's what I have so far.</p>
  <pre><code>DATEADD(D, 0, DATEDIFF(D, 0, DATEADD(s,-1,DATEADD(q, 1, DATEADD(q, DATEDIFF(q, 0, GETDATE()) - 1, 0))))) AS LastDayOfLastFullQuarter
  </code></pre>