Date formats

  • Thread starter Thread starter Scott
  • Start date Start date
S

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?
 
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")
 
Back
Top