I have an Access 2000 database which uses the TIME/DATE format on two fields. I can format the display to only mm/dd/yyyy but whenever I run a query and export it to a comma delimeted, quote encapsulated text file the date appears in the same field?
How do I truncate or get rid of the date?
