Export date to acsii file with no time

  • Thread starter Thread starter stathisb
  • Start date Start date
S

stathisb

Dear All,

I use MS Access 2000 and I would like to export from a
table data to a text file. Using delimited text when I
export some fileds that have date/time data, the date is
exported with the time in the text file. How can I get
only the date and not the time?
Thanks a lot in advance
 
Use a query as the source of the exported data, not the table. In the query,
replace the table's field with a calculated field that formats the output
the way you want it:

MyOutput: Format([FieldName], "mm/dd/yyyy")
 
Back
Top