Time Added To Date When Exporting Table To .csv File

TimTDP

Registered User.
Local time
Today, 16:41
Joined
Oct 24, 2008
Messages
213
I need to export a table to a .csv file.
One of the fields in the table is "Posting Date". Data Type: Date/Time. Format: Short Date
All records in this field are dates. Format is "dd/mm/yyyy". None of the records include a time.

When I export the table to a .csv file, the time is added to the date. So the exported result is "dd/mm/yyyy 00:00:00" e.g. 17/10/2013 00:00:00
I am exporting the table using "delimited" format in the wizard.
I cannot use the fixed width option.

How do I prevent the time from being added?

Thanks in advance
 
Solved it!

Changed the data type to Text. This works for me, but would still like to know how to prevent the time from being added for future reference
 

Users who are viewing this thread

Back
Top Bottom