[AccessD] Export to CSV file problem

Hi Chester:

The real date in the table is stored Microsoft date format: i.e.
351235.12343. Its' display format can be very different from the real date
and sometimes Access assists by assigning it's own date format
recommendation when certain function are being used. I have found it is
sometimes better to create a field, format the field and then export the
contents from/through a query rather than directly from a table.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kaup, Chester
A
Sent: Monday, October 25, 2004 2:48 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Export to CSV file problem


I have the following field in a query that makes a table.
Date: Format((CDate(Forms![frm Select Date]!selected_date)),"Short
Date")
When I open up the table I see a short date
When I export the table to a csv type file I get both the date and the
time.
How do I get only the date into the csv file?

Chester Kaup
Information Management Technician
IT-MidContinent/MidContinent Business Unit
CTN 8-687-7415
Outside 432-687-7415

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com