Exporting Date field without a time and without a delimiter

[redjessie]

I'm trying to export from MS Access 13 to a .csv file, with data from a query, where 1 field has date/time format in the underlying Access table.

Without any functions on that date field it exports to a csv file with 00:00:00 at the end, which I then have to manually strip from the file. I'd like to eliminate that extra step if possible.

I've done some research and most common answers are to use either DateValue or format([DateField,"YYYY-MM-DD]).

The former gives the same results as using no function, and the latter trims off the time, but treats the field as a string and adds delimiters, which I do not need, as the file is an import to another process, and they only want delimiters on text fields, not date fields.

Are there any other options?

TIA.

 

[Ranman256]

You can export the date in any format. Tho it's no longer numeric, that only leaves a string.
You can export without delimiters. Dates can be recognized from strings, or as numeric, or as dates.
They are pretty flexible.