Currently my files are being imported over using ODBC. With dates like, 112603 since these are text I have to convert this in order for Access to interpret the numbers like so,
Date: CDate (Left ([myfield], 2) & "/" & Mid ([myfield], 3,2) & "/" & Right ([myfield], 2)), with the results like 11/26/03. Now the file is coming over like 11262003220927. How can I modify the expression to include both date and time? Like 11/26/2003 22:09:27.