Date Data format error

[abbytank]

Hi everyone,

While trying to import data source from excel with the following data:

ProductKey	CustomerKey	Sales_Date	Quantity
2233	19069	12/6/2022	1
1872	1646	12/6/2022	1
1872	1645	12/6/2022	1
1872	1638	12/6/2022	1
1872	1635	12/6/2022	1
108	19063	12/6/2022	1
1703	17685	16/6/2022	1
1703	17684	16/6/2022	1
1703	17568	16/6/2022	1
1703	17567	16/6/2022	1
1705	13201	19/5/2022	1
1705	13200	19/5/2022	1

The power query is showing the following error:

DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
29/2/2021

Here is what I did, I have changed the data type using locale with data types of English(UK) sample: 29/03/2022 and English(US) sample: 03/29/2022, none helped.

I have also, splitted the column to three columns and remerged, and still not working. 

Please help.

Thank you in advance.

[serpiva64 · Accepted solution]

Hi,

you have a problem in your data.

2021 is not a leap year so you can't have 29/2/2021 and that's the cause of the error

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !