exporting delim file

[Gals]

I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .

 

[Nikos Yannacopoulos]

An easy way around it is to create a new query based on the previous one
with no filtering, including all fields of the original but the date field,
and with the addition of a calculated field on the date field like Date:
Left([DateFiled],10)
and export this one instead of the original one. As a result of the Left()
function the date is coverted to text, but for the purpose of exporting to a
text file it makes no difference whatsoever.

HTH,
Nikos

 

[Gals]

Thenk you but now it comes like
"dd/mm/yyyy" i need it without the " " like thate
dd/mm/yyyy
Thenk's again

An easy way around it is to create a new query based on the previous one
with no filtering, including all fields of the original but the date field,
and with the addition of a calculated field on the date field like Date:
Left([DateFiled],10)
and export this one instead of the original one. As a result of the Left()
function the date is coverted to text, but for the purpose of exporting to a
text file it makes no difference whatsoever.

HTH,
Nikos

I'm trying to export a text file frome a query using :
" DoCmd.TransferText acExportDelim "
I hava a problem with a short date fileld thet comes out with the trime :
dd\mm\yyyy 00:00:00 - I need only the date part without
the time .