Format General date format into short date when exporting

  • Thread starter Thread starter Ruthie
  • Start date Start date
R

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.
 
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;
 
Back
Top