4 Ways To Fix Your Power Query Date Errors Locale

thank you Jon.!

Thank you so much it was very useful

It really helped me! thanks

I've used one or two of these methods before, with success. Today I downloaded 'balance affecting activity' as a CSV from Paypal Canada and none of the 4 methods you show are working. I'm in Canada and am used to my excel getting confused about the day/mo/yr vs mo/day/yr, but this is very odd.

Thankyou, custom locale was the best tip. American dates smh

Thank you very much!

Thank you

Amazing As Usual :)

Thank you very much, I was solving tis prob for awhile and then I found your video which helped me solved this prob

Thank you, Jon. Before I retired, I worked for a Japanese company that used the ISO date format yyyy-mm-dd, and after a lot of frustration, I stumbled on the operating system fix. I didn't know about Power Query then, nor your excellent solutions.

Love this video 🙂

It is very informative but i have an issue, I have imported a file and my date column is m/d/y format and i want to change it in d/m/y format but problem is all dates which are not as text format already converted as date suppose, 1st feb converted to 2nd jan autometically, which is wrong

Thanks for the video. Applied the first step and problem was solved

Thank you for sharing the useful information............................

A lot of thanks

Thank you for the help..

😀 Thank you so much... !!

Thank you for this tips!!! I liked a lot, see you later.

Still getting error for dates before a particular year say 1954. How to address that?

Excellent Really Excellent...

Thanks a lot man.
This will help me a lot

Awesome explanation ☺️

Thanks a lot. This is so helpful and it saves my day.

Thank you very much

Half of my dates are mm/dd/yyy and half are dd/mm/yyyy in one column. What to do now?

Can't quite believe it , I encountered this problem this morning and didn't know how to fix it without changing windows regional settings. I wasn't even looking for a solution, just selected by chance.
As with all your videos you have a very clear and relaxed way of explaining things.

Thanks for the great video! That clears up how to IMPORT dates from data sources that have different locals. Does anyone here know how to then SHOW values in a specfic way, regardless of end users' locales? (specifically numeric values). In Tableau it's so easy to force the display format, by selecting which symbol to use for thousands separator, and which symbol to use for decimal seperator. Seems impossible in Power BI.

Thank you for this tutorial. However, I have encountered a different scenario today, my dataset has two different date types E.g 7/01/21 & 01/7/21. How to can I fix this, Thank you

Thank you very much for the tutorial. The 4th part solved my problem, thanks again!

Hi Sir, i followed the steps but it still did not work :(...But Thanks a lot. May be issue with the file. I will create a new file and try. :)

Thanks a lot bruv. Before looking at your video, I tried many other solution. Your solution worked like a charm..

Very well Sir John, thanks to my increase knowledge...

I did that and the format is ok in power query but when I load it in the table it just appears as numbers
instead of dates. Anyone has any solution?

Thank you. Regarding creating extra column by example, what if you have the dates spread across two or more columns? As you probably know, real life problems do not come as easy as having the dates all put together under one column. 100% of the time you will have them rather spread across multiple columns and where some of these relevant columns containing dates do also contain other important stuff - that's the real life challenge that makes power query somewhat useless. Since cleaning is where the real challenge is, we'd all appreciate if you could tackle in more videos more cleaning challenges. Imagine you have daily report workbooks each containing just one sheet. Although all sheets follow similar pattern (i.e. name, surname, employee ID, role etc.), yet the columns containing a specific data (i.e. name) often get replaced by a column or two (because of converting .pdf into .xlsx). In other words, while name was reported under column C in one report, it gets reported in column D in the other report. And in the third report it gets reported in column E! That's the real challenge.

Amazing ... i already was having such a problem ...thanks a lot

million thanks

Yes it very helpful tips

Awsome Tutorial. Exactly to the point. Thanks a lot.

Thank u so much sir

excellent explanation, thank you Jon

Hi Jon.. great tutorial.. demystifies the issue of date formats across regions and how to handle them. Thanks for sharing. Thumbs up!

MULTIPLE TIME REPET
DATES I NEED THIS 
02/03/2020 02/03/2020
02/03/2020 04/03/2020
02/03/2020 05/03/2020
02/03/2020
02/03/2020
02/03/2020
04/03/2020
04/03/2020
05/03/2020
05/03/2020

Jon, in the blog, you could download the file to practice. But it is missing the csv files. Thanks

John, thanks for the video. It is very clear and usefull. In the las example, maybe you could also substitute the "--" for the "." and then convert to date.

Us mathematicians insist that yyyy/mm/dd is the only reasonable way to do it. It's the only format that sorts OK as text, as numbers (without the punctuation), or as dates. I always use this approach in file names, where it's the only way to get sorts right.

Well explained .... I have a question... how did u get the option "Add column" in the Ribbon bar?? ... I am using excel from Office 365 latest version but I tried to add this option and it doesn't exist ... can u give me a hint??

As always, great! thank you

Excellent demonstration Jon, always enjoy your videos...