Exporting dates in fixed length format.

[jfaz]

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.

 

[Guest]

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)