Export Function Date Format

[BAWC01]

Hi

I'm exporting a query to a file using

     DoCmd.TransferText acExportDelim, "Export_AP INV DISTR", "AP INV DISTR", GlobalOUTPUTLoc & "\" & "AP INV DISTR.csv", True

This works fine expect when I look at the file

Supplier	Description	Inv Date	Inv Number	Net
100171	travel	08/12/2005 00:00	NOV.05 EXP179	120.04
100264	btb	08/12/2005 00:00	TT178	42.55
100264	Expenses nov3	08/12/2005 00:00	BBCNANOV3156	68.09
100264	Export Test 2	08/12/2005 00:00	BTBCNATEST2173	145.8
100264	November expenses 3	08/12/2005 00:00	BBCNANOV3171	72.34

The INV_DATE has 00:00 after the date !!! I just want the date, there is nothing in the Export Wizard that I can see that will get rid of it.

Phil

 

[edsuk]

Modify the query

Inv Date: Format([Inv Date],"dd/mm/yyyy")

to format the Invoice date as required.

HTH

Mark...

 

[BAWC01]

Hi

I have done this but I still get it ?

Phil

 

[JerryKlmns]

And this field Inv Date in your table is a Date/Time field?

 

[JeffHawkins]

I have the same problem. Trying to export to a tab delimited (no text delimiters) .txt file. In a query, have tried...

MyDate: Format([DateField],"mm/dd/yy")
MyDate: CStr(Format([DateField],"mm/dd/yy"))
MyDate: CStr(Format([DateField],"mm/dd/yy")&" ")

No matter what, It always comes out in the text file as:
2/22/06 0:00:00

The KB says to do what I did in the first case above, but it doesn't work. Any help would be greatly appreciated.