Hi,

I have a Power Query table in an .xlsm workbook with a field [Period] that is type date and has the first day of each month. I am in Sydney, so format is dd/mm/yyyy.

Excel_Period.JPG

I want to save the sheet as a .csv file, however the .csv file has "day" & "month" swapped around. So 1/07/2018 has been converted to 7/01/2018. The below screenshot is from when I have tried to use the csv as a source in a new Query but it also happens when I try to open the .csv file in Notepad.

Excel_Period2.JPG
Notepad_Period.JPG

I have never seen this before.

Any ideas?