Forum Discussion
Error when converting text to date
Hi There, I have four columns containing dates in this format that are by default read as text: When i try to change the data type into date unfortunately power bi delivers many erro...
Looks like the default date format / regional settings don't agree with the format of the data . for example 17/06/2021 or 06/17/2021
This is quite common. Decide which one is correct and either change the date settings in powerbi or use the power query Change Type->using locale
HotChilli
Community Champion
Community ChampionLooks like the default date format / regional settings don't agree with the format of the data . for example 17/06/2021 or 06/17/2021
This is quite common. Decide which one is correct and either change the date settings in powerbi or use the power query Change Type->using locale
Works like a charm using the local date settings, THANKS A LOT!!