Exporting to a text file

D

Dennis Kline

I'm trying to export to a text file with criteria that my date be mm/dd/yy.
It's that way in my tabe, but when I export it it show mm/dd/yyyy 0:00:00.
Very frustrating and used to be fine in 2003? Help!
 
D

Douglas J. Steele

Create a query based on the table, and use the Format function (with a
format of "mm/dd/yyyy") around the date field.

Export the query instead of the table.
 

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

XML File - Date field formatting? 1
Export Date to outside system 5
Date Format Incorrect on Export 1
Dates in Export Specification Inconsistent in results 1
Exporting date to a text file 5
Date format when exporting to Excel 2
Date format exporting in 2000 1
Export screws up date format even in one table database 4

Top