Exporting date fields to txt

  • Thread starter Thread starter jasrain
  • Start date Start date
J

jasrain

When I export a short date value to a delimited text file
Access inserts the time stamp of 0:00:00 along with the
date even thought the time stamp is not part of the field.

How can I prevent this from occurring?
 
Use a query that has a calculated field in place of the real date field:

DateOnly: DateValue([DateFieldName])
 
Back
Top