title: CDate type mismatch error
body: <p>I'm trying to convert a text field into a date using CDate() in a recordset but keep getting a type mismatch error. The input text format is MMDDYYYY. Does CDate not recognize this format? Do I need a separate function? Any ideas?</p>
  
  <pre><code>Text Date  -&gt; Converted Date
  ---------     --------------
  04122012   -&gt; 04/12/2012
  
  
  Dim db As DAO.Database
  Dim rst As DAO.Recordset
  
  Set db = CurrentDb
  Set rst = db.OpenRecordset("tbl_dates", Type:=dbOpenDynaset)
  
  Do Until rst.EOF
  rst.Edit
  rst![Converted Date]=CDate(rst![Text Date])
  rst.Update
  rst.MoveNext
  
  Loop
  
  Set rst = Nothing
  Set db = Nothing
  </code></pre>