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 errors:
I also tried analyzing these errors, such as:
The text says: "It was not possibile analyzing the specified input as Date value"
How can i solve this?
Thanks!
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
2 Replies
- HotChilliCommunity Champion
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
- AnonymousNot applicable
Works like a charm using the local date settings, THANKS A LOT!!