May 02 2022 10:17 PM
Some dates in DOB column are in text format and text-to-colums is not working. How to convert these into date format
May 02 2022 10:24 PM
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.
May 02 2022 10:24 PM
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.