Forum Discussion
Help on Date Format conversion
I have 2 Excel files with a Source that has this Column 'Date' (see below) in my 1 Excel it converts fine but in the other it converts it to Month as Date and Date as month see other image below. ...
| Date |
| 8/1/2021 |
| 9/1/2021 |
| 10/1/2021 |
With the above sample date column in excel, I get the correct date with either excel connector and enter date feature in Power Query. I cannot reproduce the 1/4/2021 format in the PQ, that turns the April 1st to Jan 4th.
Please try with Power Query in power bi desktop. This problem could be the Excel Power Query.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.