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

Short Time

P: n/a
Does an Acces table with a Date/Time field formatted to Short Time have
a date stored in that field as well? If so, how can I extract it in a


Apr 20 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
As far as I can tell, it doesn't store the date part of the general

I created a short time field and then wrote this query to try to
extract the date:

SELECT Table1.MyShortTime, Format([MyShortTime],"mm-dd-yyyy") AS
FROM Table1;
the result from the query was:

which is date=0.

Apr 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.