Forum Discussion
Date format error
Hello everybody, when I update my input file PBI returns me an errore about Date Format. The problem is that it returns me that error only on a specific value, whereas it's able to convert all th...
Anonymous
Please check if you turn on the "Auto detect column type" and set a proper locale.
See: Flawless Date Conversion in Power Query
Regards,
MarcelBeug
Community Champion
Community ChampionProbably your current culture expects dates in mm-dd-yy format instead of dd-mm-yy.
In that case all other dates may be misinterpreted a well, e.g. Jan-12, 2016 is in fact Dec 1, 2016.
The solution would be to add an additional argument at the end of your code with the culture code (or Locale), that suits your data.
An example is the code for The Netherlands (Dutch): "nl-NL".
You can also find this functionality when you click the data type button at the top left of your column header or if you right click the column header and choose " Change Type" using Locale.