title: Pulling prior year data
body: <p>I am working on a query to pull all turnover in the past calendar year that is going to be used daily. Rather than going in and having to change the date each time I would just like to be able to run the query and have it automatically only pull the last 365 days worth of data. The code  itself looks like:</p>
  
  <pre><code>SELECT O867IA_VJOBHST.SYS_EMP_ID_NR, O867IA_VJOBHST.REC_EFF_STT_DT, O867IA_VJOBHST.EMP_ACN_TYP_CD
  FROM O867IA_VJOBHST
  WHERE (((O867IA_VJOBHST.EMP_ACN_TYP_CD)="HIR"));
  </code></pre>
  
  <p>Where the REC_EFF_STT_DT is the date the ACN_TYP_CD occurred, in this case when they were HIR (Hired)</p>
  
  <p>Any Ideas?</p>