title: Convert nvarchar to date and Get data between two date
body: <p>I'm collecting data between two date 01/12/2014 and 31/12/2014 but my sql data type in nvarchar </p>
  
  <p>is my query right?</p>
  
  <pre><code>SELECT * from customer where date &gt;= convert(datetime, '01/12/2014', 105) 
  AND  date &lt;= convert(datetime, '31/12/2014', 105)
  </code></pre>
  
  <p>Result</p>
  
  <pre><code>Msg 242, Level 16, State 3, Line 1
  The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
  </code></pre>
  
  <p>can any one solve this problem...</p>