title: How to get YTD data in SQL
body: <pre><code>where (au.[DateTime]&gt;= DATEADD(WK,-12,GETDATE()) AND au.[DateTime]&lt; GETDATE())    
  --gets everyday for the last 12 weeks
  </code></pre>
  
  <p>How can I modify to get every day for YTD?</p>