Date/Time in Advanced Filter/Sort

[Scott Dunham]

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?

[Phil Stanton]

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?