Time still showing up in my export

M

Michael

I have 2 queries I export with a small module that have date elements. I
export both to a CSV file. One does not have the time on the end of the date
the other does. I have tried both manual exports and macro'ed exports with
exact results. I have a separate schema.ini for each query. Here is my
query layout (partial) and my code

Query date column
First is the one that still gives time

Column format
invoice_date: Format([date_invoiced_soa]), "yyyy-mm-dd")

Code to export
DoCmd.TransferText acExportDelim, "dsdelim", "queryname", "Y:\filename.csv",
False


Here is the one that works it is identical to me

Colun format
order_date: Format([invoice_date], "yyyy-mm-dd")

Code to export
DoCmd.TransferText acExportDelim, "pbkodelim", "query2name",
"Y:\filename.csv", False

I am thinking that there is something different in the schema.ini files,
however to the best of my knowledge I set them up the same. When going
through the export wizard screens manually in both cases my date column is
enclosed in quotes, and looks like the following:

"2004-07-10"^2.58^"SMITH"

Second Export looks the same:

"2004-07-10"^1.43^"SMITH"

(I use the"^" as my delimiter")

When I view the first with Excel or a Text editor they both show 2004-07-10
0:00:00

When I view the second with Excel or a Text editor they neither show the
time element.

I can't figure out why.

Any help is greatly appreciated.

Thanks
 
Top