Exporting a date column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I export a date column to a csv file I always get the date followed by
"0:00:00", is there any way to get rid of this time portion withiout using
the local settings which may vary from machine to machine. I looked in Access
Help but it gave no examples forthe Format function.

Thanks.
 
mscertified said:
When I export a date column to a csv file I always get the date
followed by "0:00:00", is there any way to get rid of this time
portion withiout using the local settings which may vary from machine
to machine. I looked in Access Help but it gave no examples forthe
Format function.

Thanks.
Click to expand...

Use a query to export instead of a table. In the query use the Format()
function (not the format property) to set the format of the date as desired.
 
You must log in or register to reply here.

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

Pivot table macro filter data between yesterday and today (date+time) 0
Date format when exporting 2
Access General Date Forced To Have Date And Time 2
Exporting a date field 2
Problem formatting dates from CSV file 2
A Date comparison problem 2
suppress 12:00 time 1
Please help! date showing as 1900/01/00 2

Back
Top