need help with dates

New Contributor

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

Screenshot (54).png


2 Replies
best response confirmed by shergill_13 (New Contributor)

@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.



thanks man it worked