Dataformat get mixed up in CSV file.

[DanNielsen]

I have some VBA code that generate a CSV file from a Customer database with dates (I need to reed the data in MailChimp).
In the excelfile everything look finde all dates in column is in date format and written as i like dd-mm-yyyy hh:mm:ss (Danish format). (I don't need the time)
But when I (using VBA) convert it to CSV file some of the dates at written incorrect:
Some has changed to mm-dd-yyyy and what was "dd" is written as "mm" (Date of month it changed to month nr.). The cell is in danish date format dd-mm-yyyy
Some has changed to mm/dd/yyyy (dont know if the date of month is changed to month nr.). The cell is in "standard" not date format and if i try to change it to date format (Danish dd-mm-yyyy) nothing happens.

What can I do to make sure dates are being converted correctly in csv?

Original:
06-02-2018 (06-02-2018 17:02:29) (Read in cell)
10-02-2018 (10-02-2018 13:04:54) (Read in cell)
12-02-2018 (12-02-2018 10:20:58) (Read in cell)
16-02-2018 (16-02-2018 12:25:35) (Read in cell)
20-02-2018 (20-02-2018 14:55:01) (Read in cell)
23-02-2018 (23-02-2018 14:41:08) (Read in cell)
27-02-2018 (27-02-2018 10:31:35) (Read in cell)

CSV file aften open in excel:
02-06-2018 (Read in cell as the same whiteout time)
02-10-2018 (Read in cell as the same whiteout time)
02-12-2018 (Read in cell as the same whiteout time)
2/16/2018 (Read in cell as the same whiteout time)
2/20/2018 (Read in cell as the same whiteout time)
2/23/2018 (Read in cell as the same whiteout time)
2/27/2018 (Read in cell as the same whiteout time)

[Keebellah]

If I save it as csv it remains the same

I think you should not do save as csv but use a macro to generate the csv file and than you can include the date format when writing it

This is typically one of the many issues with Excel and date and time formats.

All dates before the 12th day of each month will work but after that the month and day get switched and Excel 'invents' it's version of it

[DanNielsen]

thank you but I'm not sure what you mean?
I save using VBA macro:
Filepath = ThisWorkbook.Path & "\"
ActiveWorkbook.SaveAs FileName:=Filepath & "ServiceMailList.txt", FileFormat:=xlTextMSDOS, CreateBackup:=False

Could you give me the VBA code i should use to get the dates correct?

[Keebellah]

Since you did not post the workbook with the macro I had no idea what or how you were doing it.
I don't know what more fields you have to export
Take a look here for ideas: http://www.morgantechspace.com/2015/...-csv-file.html