Forum Discussion
Date Data format error
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.
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 !
1 Reply
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 !