DateTime Query 1

[Sunwriter]

:Access 2002, SP3

I have a datetime field that I need to query as follows:

Between #2/20/2006 4:00:01 PM# And #2/21/2006 4:00:00 PM#

So that I don't have to re-enter the date portion each day...

How can I re-design this critera to look back (from 4:00.00 PM) each day, to 4:00.01 PM the prior day? Or back 23hrs, 59min, 59sec. if you want to look at it that way?

Thanks in advance for any assistance.

Jeff

 

[PHV]

You may try this:
Between Date()-1+#4:00:01 PM# And Date()+#4:00:00 PM#

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DotNetGnat]

use

dateadd() and now() functions...

-DNG

 

[DotNetGnat]

i think its date() in access instead of now()

-DNG