title: Convert NVARCHAR Date to Date/Datetime Format
body: <pre><code>OrderCreatedDate
  9/20/2013 12:01:59 AM
  </code></pre>
  
  <p>Data is imported from a CSV as <code>NVARCHAR</code>, I would like to convert this in to <code>date</code> or <code>datetime</code> format</p>
  
  <p>However, if I try and import it as a date/datetime it mixes up the months/days on some of the records strangely</p>
  
  <p>If I try and cast or convert I get the follow error:</p>
  
  <blockquote>
    <p>The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.</p>
  </blockquote>
  
  <p>The date format is shown at the top of this post</p>
  
  <p>thanks</p>