By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 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
Query?

Thanks

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
date.

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
DateOfTime
FROM Table1;
the result from the query was:
12-30-1899

which is date=0.

Apr 20 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.