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

Date/Time in Advanced Filter/Sort

P: n/a
I'm trying to select records between 2 different times, but I can't
seem to get Access to see anything other than the date. For instance,
criteria "Between #11/12/2001 1:45:00 PM# and #11/12/2001 2:45:00 PM"
returns all records on the 12th. Is there a trick here somewhere?
The field is date/time format. Do I have to do something to split the
date and time apart in order to get the filter to work right?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
3 thoughts
one is the problem with UK date format dd/mm/yyyy and US format mm/dd/yyy.
It could be that it thinks you are using a US date. Check your regionsl
settings on the control panel.

Secondly there is a missing closing "#" in your criteria

Thirdly although you may key in "Between #11/12/2001 1:45:00 PM# and
#11/12/2001 2:45:00 PM" and add the hash to "Between #11/12/2001 1:45:00 PM#
and #11/12/2001 2:45:00 PM#"
it gets changed to "Between #11/12/2001 13:45:00# And #11/12/2001
14:45:00#", so why not key it in that way

Phil
"Scott Dunham" <sj******@comcast.net> wrote in message
news:fd**************************@posting.google.c om...
I'm trying to select records between 2 different times, but I can't
seem to get Access to see anything other than the date. For instance,
criteria "Between #11/12/2001 1:45:00 PM# and #11/12/2001 2:45:00 PM"
returns all records on the 12th. Is there a trick here somewhere?
The field is date/time format. Do I have to do something to split the
date and time apart in order to get the filter to work right?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.