Date Range Question

[ptrifile]

I am using the following criteria in a query to pull data between specific hours for a specific day:

Between DateAdd("h",18,DateAdd("d",-2,Date())) And DateAdd("h",19,DateAdd("d",-1,Date()))

The above works great except when trying to do the following....If i want to pull data from a range of dates, say between -1 days and -5 days it grabs all of the data from the first date to the last date, not just from in between 9am and 6pm for each day.

How can I pull data between a range of dates and only have it pull the data for each day between those times? Hope this makes sense.

Any suggestions or help is appreciated!

Thanks!

Paul

 

[JerryKlmns]

where ..... and
Cdbl([YourDateTimeField]) - Int([YourDateTimeField]) Between 0.375 AND 0.75

 

[PHV]

Another way:
... AND Format([YourDateTimeField],'hh:nn') Between '09:00' And '18:00'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ptrifile]

JerryKlmns, Thanks! that worked great for the times but how do I narrow down to date ranges? This just shows everything in the database between those times.

thanks again!

Paul

 

[PHV]

WHERE Int([YourDateTimeField]) Between Date()-5 And Date()-1
AND Format([YourDateTimeField],'hh:nn') Between '09:00' And '18:00'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ptrifile]

Thanks PHV, i didnt see your post before i posted my last question...I will try that