Exporting a date column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 31 May 2007 17:43 GMT

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.

Reply to this Message

Rick Brandt - 31 May 2007 18:01 GMT

> 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
[quoted text clipped - 3 lines]
>
> Thanks.

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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message