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

[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!

 

[Douglas J. Steele]

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

 

[Guest]

thank you - that worked

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)

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!