Forum Discussion
Date format error
Hi guys, I changed data type for a column of dates. Most are fine, but some with format of "DDMMYY" had errors. And, some others look correct to me, but Power BI was showing message "DataFormat.E...
Joycelu819 , If your source date has different format, then you can issue like that
Can you share sample data and sample output in table format?
amitchandak Thanks for your reply.
Tuesday, 30 June 2020
Friday, 26 June 2020
Tuesday, 7 Jul 20
Sunday, 5 Jul 2020
Wednesday, 12 Aug 2020
Joyce
Hi, Joycelu819
I cannot reproduce the problem. The data can be successfully converted into date type on my side.
Are there other errors in the advanced editor?
You can try to change the data type and select the region locale in advanced editor.
Best Regards,
Community Support Team _ Eason
