Export date to acsii file with no time

[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

 

[Ken Snell [MVP]]

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")