Forum Discussion
Imported dates not converting to correct format
LKO2022 When you do Text-to-columns, make sure that you choose the correct setting for the date column is step 3. Select Date and MDY as the source contains dates in the Month, Day, Year format. Now, Excel will import the dates correctly.
Alternatively, use Power Query (a.k.a. Get & Transform Data). Much more powerful than text-to-columns.
Riny_van_Eekelen I am trying on query but I don't know how to fix. I am just newbie. Can help me with my case below?
jmustany That's difficult based on a picture alone. I suspect that the dates are in fact texts and that you need to transform to real dates using a 'Locale'.
Hi Riny_van_Eekelen,
I've got answered to my problem. I spot my error when do delimiter option. I shouldn't thick any of delimiter even though "." is the delimiter here. That's solved my problem. Thanks again!
Hi Riny_van_Eekelen, thanks so much.
I'd tried to using "Locale" and change to my respective country and also English US, the error remains the same.
jmustany You shouldn't change to your local setting but to a local setting that matches the format the dates are in. That tells PQ to take the data format from that other locale/country and transform it to your own.