title: Convert date time string to date
body: <p>MS Access Table January2015 has a txndate field with the string "2015-01-01 11:48:00"</p>
  
  <p>The field type is text. </p>
  
  <p>The string needs to be converted to date/time i.e. it should appear in the same format but as a time. </p>
  
  <p>Running this query:
  SELECT Format(datevalue(txndate), "dd-mm-yyyy hh:mm:ss") FROM January2015;</p>
  
  <p>gives the output:
  01-01-2015 00:00:00
  (the time part is being ignored). </p>
  
  <p>How can I fix this?</p>