Convert Dates in Exported CSV file

[magicscreen]

I am trying to create a CSV export file that has a date field. If you look at the table in Access the date looks like mm/dd/yyyy.

I want to run the export wizard to create a spec so I can use it in a Transfertext.

I am trying to convert the date to dd-mm-yyyy.

I selected the - as the separator and the format as DMY.

When I look at the exported file, some dates are MM/DD/YYYY and some dates are DD-MM-YYYY.

Why are only some of the dates converted?

I checked the file and all dates in the column of the original table seem good (MM/DD/YYYY).

Thank you for any help received.

[NeoPa]

What is the type of the field in the Access table where these dates are stored?

I suspect that it is string rather than DateTime. Remember, strings can look like almost any other standard field type.