Date formats

[Scott]

I am trying to export a date field to text and it keeps
tagging with the time as well. How do I just export the
short date format?

 

[Ken Snell]

Exporting both the date and time parts of a date/time formatted field is the
default behavior for ACCESS when exporting to a text file. You need use a
query that has a calculated field in place of the actual date/time field,
and set up the calculated field using the Format function:

JustTheDate: Format([DateFieldName], "mm/dd/yyyy")