title: How do I find data from this day exactly one year ago?
body: <p>Right now I have:</p>
  
  <pre><code>year(epe_curremploymentdate) = year(DATEADD(year, -1, SYSDATETIME())) 
  </code></pre>
  
  <p>But that is giving me everything from last year.  All I want is the data from today's date, one year ago.</p>