I have a process that exports an Access table to a comma-delimited
text file. One of the fields that is exported shows the date it was
exported, using the Date() function. In the Access table, the date
appears in the records in mm/dd/yyyy format, but after exporting, the
date appears as mm/dd/yyyy 0:00:00. For example, today is 11/06/2003.
It shows 11/06/03 in the Access table, but the exported text file
shows 11/6/03 0:00:00. I thought maybe the Date() field had to be
specifically changed to Short Date format, but this did not solve my
problem. Because of the added 0:00:00, any fields following this date
field are not being recognized when that text file is input into a
second, larger FoxPro database. Any help is greatly appreciated.
Fran Zablocki