Exporting Dates from Access to Text Files

[Guest]

I have a date I need to export as dd-mmm-yy (11-Nov-06). If I have the
column formatted in my query as dd-mmm-yy, the date shows ok in the query
window, and in the export window, but in the final fixed length text file, it
shows as 11/11/2006. I have even tried using a formula and converting the
date to a string, and that still displays ok in the query, but exports wrong.
Is there a way I can get this date format to export to a text file in the
proper format?

Thanks in advance.

 

[Ken Snell \(MVP\)]

Use a calculated field in the query in place of the date field; in that
calculated field, use the Format function to explicitly define how the date
value is to be exported:

SELECT FieldName1, FieldName2,
Format(DateFieldName, "dd-mmm-yy") AS TheDate
FROM TableName;

 

[Guest]

Ken,

Thank you very much, that worked perfectly.