title: How to convert a text field to a date/time field in Access 2010?
body: <p>I am importing an excel file into Access 2010  and the date field(CALLDATE) comes in as text(YYYYMMDD).  I would like to use an update query to update a new field "dateofcall"  but using a date/time format. I tried to use:</p>
  
  <pre><code>UPDATE tbl_Import SET tbl_Import.dateofcall = CDate([tbl_Import].[CALLDATE]);
  </code></pre>
  
  <p>I thought it was going to be that simple but it shows up blank with a date format.  I also tried to use DateSerriel() but still was getting errors. Any suggestions?</p>