I was recently upgraded to Access 2007. I am trying to export a table
to text. My table has 2 date fields and several other fields. The
fields look fine in Access, but when I export, the field includes the
time portion of the date (which is not displayed in Access and is
causing issues for me). I searched online and saw several postings
regarding this, but the primary solution I found (using the format
function in the query e.g. NewDate: format([olddate], "mm/dd/yyyy") -
something along those lines) doesn't work for me. Again, it looks fine
in Access, but then when I export to text, the time shows up. Since
the text file needs to be uploaded into another system, it's causing
lots of issues for me. Any help is greatly appreciated. Oh, and I also
tried exporting to Excel and then converting to a .csv, but the same
issue results - looks fine in Excel, but then the time shows in the
resulting text file.

On 10/06/2011 17:07:43, Coll wrote:
You might try

NewDate = Cstr(Format("#" & OldDate & "#", "mm-dd-yyyy"))

No guarantees.

Phil