468,135 Members | 1,449 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,135 developers. It's quick & easy.

Date/Time in Advanced Filter/Sort

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
1 8565
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.

Similar topics

2 posts views Thread by zaceti | last post: by
1 post views Thread by MX1 | last post: by
3 posts views Thread by matturbanowski | last post: by
reply views Thread by Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post: by
reply views Thread by Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.