Exporting a date field

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
In the query, use something like

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

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

Thanks again.

Ben
 
Back
Top