title: Selecting Dynamic date range in sql
body: <p>I have a query which bring the data based on their Activity date. The query goes like:</p>
  
  <pre><code>where al.ACTIVITY_DATE between '2017-01-01 00:00:00.000' and '2018-12-01 00:00:00.000'
  </code></pre>
  
  <p>It select all the activity falls under this data range.</p>
  
  <p>Now as its 2019 i need to make changes on my date range as <code>2019-12-01 00:00:00:.000</code>.</p>
  
  <p>What i don't want to do is to make changes every year on that report manually. Is it possible to select data of last 2 years along with the data of this year till 31st dec 2019?</p>