Problems in changing date type

[Gomaa 72]

Hi everybody ,

How can I recover dates in the (BL1 start ) and (BL 1 finish) as shown in the image attached ?

Knowing that I took these steps when errors appeared in the first place(errors where in all the rows of the two columns ) when importing the data file:

• I checked in (options>regional settings >locale for import ) and it was (English (united states)
• I splitted the column and then merged it again with changing the data type , it worked in some rows , but still other rows showed error. When I tried (remove errors ) the whole row ,with error , was deleted from the table.
• I changed data type in the source file using ASAP in excel and this was the last step which lead to the result as shown in the attached image.

 

[sandy666]

check your source data, use Text2Columns to standardize dates
check local settings (windows) for date format, check regional setting in PQ , both should be the same
check source data against additional hidden characters

 

[sandy666]

after text2columns change format to Genera, if you will see numbers not a date this is ok, if some numbers and some dates that means your dates are still as text so if you set column to date format in PQ it will give you an error