title: Find data with specific date and month only
body: <p>I am trying to find a data with specific where clause of date and month but I am receiving an error can anyone help me with this?</p>
  
  <pre><code>select *
  from my_data
  where date BETWEEN '11-20' AND '12-15'
  </code></pre>
  
  <blockquote>
    <p>MS SQL Server Management Studio</p>
  </blockquote>
  
  <p>I am receving an error </p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string</p>
  </blockquote>