I have an Access table with a field DueDate as a text field. This field contains a date and time in a string format: yyyyMMddhhmmss. How can I convert it to the type DateTime from a select query?
For example I have a DueDate field =200604010925242
I run a select query:
Select DueDate from Table1
and I want to retrieve 04/01/2006 09:25:42 instead of 200604010925242