If the built in functions don't work, have you tried the Left, Mid and Right functions. Use these functions to extract the year, month, day and time and then convert each to its date/time component. Then concanenate them together. I hope this works.