title: SQL query not pulling correct year
body: <p>I have a query </p>
  
  <pre><code>SELECT
      convert(varchar, dates, 101) 
  FROM 
      database 
  WHERE 
      dates BETWEEN '04/01/2015' AND '04/30/2015'
  </code></pre>
  
  <p>It returns all April dates but the problem is it is for every year (i.e. 2010, 2011, 2012, 2013, 2014, 2015). I think that it is not reading the last 2 digits of the year and just pulling everything from 2000 on. Am I correct in thinking this? How do I fix this?</p>