Exporting dates in fixed length format.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to export date in the format of ddmmyyyy. I have set the property of
the field to short date and used the advanced button on the export routine to
exclude the /in the date field and to include leading zeros. However when I
check the exported data the time field is also included. Is there a way I
can get rid of this. I may be missing the obvious but have looked at this
several times and cannot find out how to get rid of the time element.
 
You have only set the display properties. What you want
to do is actually convert to text in Access, before you export
The Format() function returns a string: use this as a calculated
field in a query. Export the query rather than exporting a table.

(david)
 
Back
Top