Help in export macro!!!!

[sming]

Hi,

Please help in solving this problem in programmatically
exporting the file that has date fields. Even though I
specified short date on the format from the Table Design
and when I clicked on the Advanced button thru the Export
Wizard to change the Date Delimiter and Time Delimiter the
way I want, I couldn't get rid of the time after mmddyyyy
so I have to manually do the find and replace to get rid
of all the zeros. Plus, I would like to make this a
macro, I don't know how to get the Specification to skip
the time portion in the date fields. My data only
consists of mmddyyyy.

e.g The date in the table ----> 08212003
Thru the export wizard 08212003 00:00:00


Thanks,
Sming

 

[Steve Schapel]

Sming,

Try putting a field in the query that you are exporting from like this...
DateForExport: Format([YourDateField],"mmddyyyy")