Exporting dates without the time 1

[dhanus]

Hi Experts

I am exporting data from a query to a text file.

My code is like this :

vFileName = "filename_" & Format(Date, "ddmmyy") & Format(Time, "hhnnss") & ".asc

DoCmd.TransferText acExportDelim, , "ExportDataToSAP", vFileName

My output file looks like this :

"PD",9/1/2004 :00:00,"s333","4006","1007",30000000.00,27.00,"s333"

"NT",27/1/2004 0:00:00,"S88888888888","4006","1007",30000000.00,27.00,"S88888888888"

How can I trim the date so that it appears as 9/1/2004
and not 9/1/2004 0:00:00 ??

The date format in my table is Short Date.

Dhanus

 

[lupins46]

In the query use a calculated field instead of the original field.
EDate:format(MyDatefield,"dd/mm/yyyy")

 

[dhanus]

Thank-you, lupins-46. It worked !