Exporting a Date Field (csv)

  • Thread starter Anthony Viscomi
  • Start date
A

Anthony Viscomi

I am exporting a query to a csv file that contains a date field (short
format). When I run the query the field is displayed in the short date
format (mm/dd/yy). But when I export it to the csv file and view it, the
field not only shows the date, but also the time (00:00:00). Is there a way
for the time not to be displayed or exported along with the date?
Thanks!
Anthony
 
R

Rick Brandt

Anthony Viscomi said:
I am exporting a query to a csv file that contains a date field (short
format). When I run the query the field is displayed in the short date
format (mm/dd/yy). But when I export it to the csv file and view it, the
field not only shows the date, but also the time (00:00:00). Is there a way
for the time not to be displayed or exported along with the date?
Thanks!
Anthony
Click to expand...

The format *property* only controls display. You need the Format() function.

Format([DateField],"mm/dd/yy")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date format when exporting 2
Date Format when Exporting 5
date format problems with export to csv 1
Keep Short date format when exporting a table 1
Remove time from date upon export to csv 9
Date Format Question Again 2
Problem Exporting time 3
Bad Date - Format Problem 2

Top