title: SQL WHERE DateTime is Between
body: <p>I have this query here:</p>
  
  <pre><code>SELECT * 
  FROM QuestionnaireAnswer 
  WHERE dateCreated BETWEEN CAST('20/12/2015' AS datetime) AND CAST('22/12/2015' AS datetime)
  </code></pre>
  
  <p>but I keep getting this error, how come? and how do I fix it?</p>
  
  <blockquote>
    <p>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>