export table without time format

[MICKI0220]

I am trying to create an export to a .txt file of a table with a field that is the date datatype. How do I get it to export without the added time format. Where I need to import this information, has a problem with that additional format.

I am using Access 2007

Micki

 

[SkipVought]

hi,

You must CONVERT your Date/Time NUMERIC data to STRING, using the Format() function...

select ..., Format([Your Date], "yyyy/mm/dd"), ....

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]