how to export specific date format to text file

[Guest]

Hi,
I am trying to change the date format in a table (current format:mm/dd/yyyy)
to a format required by a vendor (new format: dd-mmm-yy) when exporting this
data to a comma delimited text file.

While I can change the format for display, I can not have this correct
format show up on the comma delimted text file exported from Access.

thx
-ed

 

[Nikos Yannacopoulos]

Ed,

Make a simple select query on the table, and instead of the original
date field use a calculated one like:
MyDate: Format([DateField],"dd-mmm-yy")
where DateField is the name of the datefield in the table.
Then export the query instead of the original table, and you'll get what
you want.

HTH,
Nikos