title: SQL: Where between two dates without year?
body: <p>I'm trying to query through historical data and I need to return data just from a 1 month period: 2 weeks back and 2 weeks forward,but I need the year to not matter.</p>
  
  <p>So, if I was to make the query today I would want all rows with <code>date</code> between xxxx-06-31 and xxxx-07-27</p>
  
  <p>Thanks in advance for the help!</p>
  
  <p>EDIT:
  I've tried two ways. both of which I believe will not work around the new year. One is to use datepart(day) and the other would be to simply take the year off of date and compare.</p>