Date format error

[Joycelu819]

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.Error: We couldn't parse the input provided as a Date value.
Details:
Friday , 7 May 2019". How can I fixed all of these at the same time? Thanks.

Joyce 

[amitchandak]

@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?

[Joycelu819]

@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

[v-easonf-msft]

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