Issue with dates when saving as .csv

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?

I should have added that I am creating the .csv file via VBA with this code:

Please Login or Register  to view this content.

It seems that if I create the .csv by going to Save As & changing file type to .csv, the issue does not occur.

Thanks very much, that works!