Format General date format into short date when exporting

[Ruthie]

Hi, I have a table in Access that I am exporting into text, comma-delimited
file -- the exported dates are in general format (mm/dd/yyyy hh:mm:ss) --
while I needed those to be in the short date.

Thanks for any help.

 

[Wayne-I-M]

Hi

The normal method would be to create a query and export that, not the table.
You can create a calculated column and use the format function to set the
exported date format

SomeName: Format([DateField],"Short Date")

or

SELECT Format([TableName]![DateField],"Short Date") AS SomeName
FROM TableName;