Powerquery changing month to day

[hamohd70]

Hello,

while using power query on a folder with multiple file, I noticed that power query has changed the date field when imported from one of the files. To make it clear, I have a date/time field that is 11/05/2023 02:00:00 referring to 11 May 2023 (the cell is formatted as dd-mmm-yy h:mm:ss). However, power query imported it as 5 November 2023 !. how can I revert the date back to the correct format?

Note that the regional date is set to 11 May 2023.

 

[GraH]

Define type with locale... will do too.

 

[smozgur]

thanks RoyA. problem solved.

The answer post has been marked as the solution as confirmed. That would be a great help to future readers if you could do the same in your future questions.

 

[hamohd70]

Sure. Thanks.