By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,176 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

export to tab-delimited file adds to time to date field

P: n/a
ZBV
I have a date/time field which only contains the date. When I export the
table to a tab-delimited file, the text file always contains not only
the date but also the time (something like 09/22/20007 00:00). Is there
any way to make it only export the date?

Thanks.
Sep 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"ZBV" <zb*@ihatespam.invalidwrote in message
news:zb***********************@news.giganews.com
I have a date/time field which only contains the date. When I export
the table to a tab-delimited file, the text file always contains not
only the date but also the time (something like 09/22/20007 00:00).
Is there any way to make it only export the date?
Export a query that uses the Format function to translate the date
stored in the table into a mm/dd/yyyy string.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Sep 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.