How do I convert my text dates, example: '10/25/2005 to a real date? I import my TXT into access that looks like this 20051025 and using the DateSerial expression it comes out as text through my query, ('10/25/2005).
I need to have real dates that I can add and subtract days too. Am I on the right track by using the expression VAL?
My mistake, I saw the (') in front of my dates and assumed they were still text. I ran everything through and they seem to add and subtract fine but was told by a c-o-worker of mine that they were no good?
He wants to format them as MMMMM-DD-YYYY and they wont format? I'm happy the way they are.