title: Select records where date between current date and current date - 2
body: <p>Here's what I'm running now, it should be giving me all the parts that have sold between today and 2 years ago. What's wrong with my query?</p>
  
  <pre><code>SELECT PART_ID
  FROM CUST_ORDER_LINE
  WHERE PROMISE_DATE BETWEEN (GETDATE()) AND (SELECT DATEADD(yyyy, -2, GETDATE()))
  </code></pre>