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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.