Forum Discussion
Solved
Incorrect date format when using text to columns
I've got an issue when I am importing a text file and using the text to columns function where its not recoginsing the correct date format in one of the columns. The text file is generated from a sy...
Craig, it looks like due to time added to that field. If time is not important for you (i.e. it always 0:00:00) you may open csv file and Text to Columns last column with space separator, remove time only column after that.
See result attached. If the time is important will find somethin else.
Hi Craig
On third step of the wuzard select correct date format for that column (US one in your case)
Hi Sergei - I've tried this method also but it still ends up with the same results. It converst the ones with days less than or equal to 12 and ignores the rest !! Very frustrating.