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...