title: Get date range between dates having only month and day every year
body: <p>I need to get date range between 1st July till 31st October every year. Based on that I have to update another column.</p>
  
  <p>Date field is datetime. Should be like this below: </p>
  
  <pre><code>Select Cash = Case When date between '1st July' and '31st October' Then (Cash * 2) End
  From MytTable
  </code></pre>
  
  <p>Note: this range should work for each and every year.</p>