Can date field from Access tbl be transfered to a txt file in mm/dd/yy 1

[Katya85S]

I'm transferring Access Table data to a .txt file. I want the Date field to hold only date information (mm/dd/yyyy format), but somewhat it transfers hours, minutes and seconds as well, although in the table dates are displayed in mm/dd/yyyy only. I've tried ShortDate format for the date field in the Access table. Didn’t' help. I've switched Date type of the field to the Text type. But still, when transferred to the .txt file it converts my text type dates into long date format with 00 for hours, minutes and seconds. Any idea how to avoid such conversion and have those dates displayed just in mm/dd/yyyy format?
I would appreciate any suggestions.
Thank you all in advance.

 

[AlexCuse]

I think you want to export from a query, and rather than exporting your date/time column try

Format(DateColumn, "mm/dd/yyyy")

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[Katya85S]

Many thanks, Alex! With query it works!
Thanks a lot