Export to txt files adding unwanted hh:mm:ss not in original data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003 and am exporting data to a txt file. I have three
date fields. In the original table and in the query, these fields are
formatted as short date, yet they are winding up in the txt file with an
unwanted time stamp:
1/1/1994 0:00:00

There is an export specification attached to the export function, but I do
not see a way to check the field parameters to make sure that the incorrect
format isn't resulting from the spec.

Is there something I can do to ensure that the date stamp won't be in the
txt file?

Thanks for you help!
 
I suspect you're using the Format property, and not the Format function.

In other words, use SELECT ..., Format([MyDateField], "mm/dd/yyyy"), ...
FROM MyTable
 
thank you - that worked :-)

Douglas J. Steele said:
I suspect you're using the Format property, and not the Format function.

In other words, use SELECT ..., Format([MyDateField], "mm/dd/yyyy"), ...
FROM MyTable

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Heart-of-Dixie said:
I am using Access 2003 and am exporting data to a txt file. I have three
date fields. In the original table and in the query, these fields are
formatted as short date, yet they are winding up in the txt file with an
unwanted time stamp:
1/1/1994 0:00:00

There is an export specification attached to the export function, but I do
not see a way to check the field parameters to make sure that the
incorrect
format isn't resulting from the spec.

Is there something I can do to ensure that the date stamp won't be in the
txt file?

Thanks for you help!
Click to expand...
Click to expand...
 
Back
Top