Exporting date fields to txt

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

Ken Snell

Use a query that has a calculated field in place of the real date field:

DateOnly: DateValue([DateFieldName])
 
Top