Exporting a date field

[Ben]

Hi all -

I have in my code to export a query into a txt file:

DoCmd.TransferText acExportDelim, , MyQueryName, FileName, True


There are two fields in the query which are of date type, but when I
open the txt file, Access added the time like this: 2/27/2009 0:00:00,

What do I need to do to get rid of the 0:00:00?

Thanks,

Ben

 

[Jim Burke in Novi]

In the query, use something like

MyDate: Format(YourDateField, "MM/DD/YYYY")

 

[Ben]

Jim,

That worked out very well. Silly me, I should have thought of that.

Thanks again.

Ben