title: SQL Server - get next Friday in DATETIME
body: <p>To get the last Friday of any date the query follows:</p>
  
  <pre><code>SELECT DATEADD(d,-1-(DATEPART(dw,GETDATE()) % 7),GETDATE())
  </code></pre>
  
  <p>How can I get the <strong>next friday?</strong></p>