title: Converting UK format date to datetime
body: <p>I have a value in SQL that represents a date, but it of type nvarchar. The value of the date is in the format:</p>
  
  <pre><code>dd/mm/yyyy hh:mm
  </code></pre>
  
  <p>I need to present this column via a view to a CCure 800 database in <code>DATETIME</code> format. I expected to use <code>CAST</code>/<code>CONVERT</code>; however, when using this, the following error is returned:</p>
  
  <blockquote>
    <p>Msg 242, Level 16, State 3, Line 1<br>
    The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>