need help with dates

[shergill_13]

Some dates in DOB column are in text format and text-to-colums is not working. How to convert these into date format

[#2 · Accepted solution]

@shergill_13 I suspect your system recognises dates in the mm-dd-yyyy format. So, TTC fails when it sees a date like 13-1-1970, as there is no month 13. Make sure that in step 3 of 3, you set the date format of the text to be imported as DMY. Then the dates will transformed to your local (default) date format.

[#3]

thanks man it worked