Date fields in an ASCII delimeted file

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?
 
K

Ken Snell

Use a query as the source of the export (based on the table), and then
replace the real date/time fields with calculated fields that you make look
like this:

ModifiedField: Format([DateTimeFieldName], "m/d/yyyy")

One calculated field for each date/time field, and name each calculated
field differently.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date fields in an ASCII delimited file 3
Paste to excel from word - auto format problem 1
Finding the right style field in VBA 0
separating date and time 5
Finding the proper style field and the numbered paragraph value within the style 0
unicode to ASCII conversion 1
merging ascii files 4

Top