exporting dates to a tab delimited file

[Randy]

i have a small table, about 14,000 records. currently all the dates in the table are YYYY-MM-DD 00:00:00. so 2007-2-28 00:00:00

I built a query and set the format to MM/DD/YYYY when I run the query the date showed correctly 02/28/2007 (no time stamp). However when I did the export it exported to the TXT file as 2007-2-28 00:00:00 (notice the months is only 1 character and it added the time stamp and it exported as the table format, not the query format)

I need to export this to a tab delimited file to send to another person. They are specifying MM/DD/YYYY (no time extension) and two characters for month and day regardless of day, i.e 02 not 2 etc.

I looked at access help, and have done a quick search, and I can not figure out how to do this.

Any help would be appreciated

 

[neileg]

Applying a format in the query doesn't change the data, just the display. To change the data, add a calculated field and use the format function, Format() on your date.

 

[Randy]

thanks for the answer

thanks for the answer, I understand.