Date fields in an ASCII delimited file

  • Thread starter Thread starter David Howlett
  • Start date Start date
D

David Howlett

I am exporting a table to an ASCII delimited file. All my date/time fields
export with a time stamp (i.e. 5/4/2004 03:04). I want the ASCII file to
contain only the date without quotes (5/4/2004).

How can I do that?
 
David Howlett said:
I am exporting a table to an ASCII delimited file. All my date/time
fields export with a time stamp (i.e. 5/4/2004 03:04). I want the
ASCII file to contain only the date without quotes (5/4/2004).

How can I do that?
Click to expand...

You can lose the time by exporting a query that applies the Format
function to your date field to convert it to a properly formatted
string; e.g., Format(DateField, "m/d/yyyy"). Then specify "{none}" for
the text qualifier in the export wizard.
 
Back
Top