title: How to dynamically update dates every year for a query?
body: <p>I have a where clause in a SQL statement that hard codes two dates using a between function. I would like to have those dates be more dynamic and update every year with out manually changing it. Using the GetDate function in some manner. </p>
  
  <p>I have tried using variations of getdate and it does not work. </p>
  
  <p>My current code looks like this</p>
  
  <p>Where Date between '1/1/2018' and 1/1/2019'</p>
  
  <p>I need this to update every year once a a new year starts in January.</p>