export table to txt file date error

[MICKI0220]

Does anyone know how to get the date without the time extension when exporting to a txt file. I am trying to create a specification so it is automated through text, but the date field keeps putting the time stamp. My external program that uses this file has an issue with the date in this format.

Any help is greatly appreciated.

Micki

 

[StarPassing]

Export using a query, not a table, and format the date field in the query the way you want it.

Tom

 

[MICKI0220]

I figured it out, in the make table query I added cstr([date]) and then ran it.