export table without time format

MICKI0220 · Nov 8, 2011

I am trying to create an export to a .txt file of a table with a field that is the date datatype. How do I get it to export without the added time format. Where I need to import this information, has a problem with that additional format.

I am using Access 2007

Micki

SkipVought · Nov 8, 2011

hi,

You must CONVERT your Date/Time NUMERIC data to STRING, using the Format() function...

Code:

select ..., Format([Your Date], "yyyy/mm/dd"), ....

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

export table without time format

MICKI0220

IS-IT--Management

SkipVought

Programmer

Similar threads

Part and Inventory Search

Sponsor