Exporting Dates

[houseofturner]

I have a query which exports to a tab delimited text file. One of the fields is created on the fly and uses the code Date().

Whilst this shows as (for example): 27/10/2011 when I view the data, when I export it and open the text file is shows as 27/10/2011 00:00:00.

I have tried formatting with no real luck.

A bit of research suggest this may be an Access bug but is there a way round it?

 

[spikepl]

export not Date() but Format(Date(),"Short Date")