Export a date field without the time (access 2003 & 2007)

[Nico]

Hi,

I am sure that this post has been done a hundred times before, but I can't
find an answer... So, sorry if I go on about it.
I do a lot of queries which I then need to export in Text files, but I want
to get rid of the time (the annoying 00:00:00 that pops up at the end of
each date).
I know I can select my imports/links to treat the date field(s) as a text
field and it exports well, but that reduces the scope of what queries I can
run (for example, based on days or months, or years etc..)
Can anyone give me a clue as to how I can achieve this?

Thanks a million in advance

 

[Douglas J. Steele]

Create a query and use the Format function (not the field's Format property)
to control how the date appears.

Export the query, not the table.