title: Convert multiple date formats stored as text
body: <p>I have a column that is a date column that is stored as text.
  This has three formats in it.</p>
  
  <ol>
  <li>dd mmm yyyy</li>
  <li>MM/dd/yyyy</li>
  <li>yyyy-mm-dd</li>
  </ol>
  
  <p><a href="https://i.stack.imgur.com/rkcps.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rkcps.png" alt="enter image description here"></a></p>
  
  <p>I need to convert all these to one format. Im hoping 112 (yyyymmdd)</p>
  
  <p>can anyone help as I keep getting an out of range error.</p>
  
  <p>I have got it to return this correctly </p>
  
  <pre><code>CONVERT(varchar(10), ISNULL(CAST(cf3.FieldValue as date),CAST('01/01/1900' as date)),101)
  </code></pre>
  
  <p>But I cant seem to then convert to yyyymmdd format without the range error.</p>