Filter records by time range within a date range

[jkupov]

What is the easiest way to do this? I want to select all records (using a date/time field)that are between 8am and 5pm from 10/01/05 - 10/31/05.

I don't want to view the records where this field is stamped with times outside of business hours.

Thank you!

 

[PHV]

WHERE ([date/time field] Between #2005-10-01 08:00:00# And #2005-10-31 17:00:00#)
AND (Format([date/time field],'hh:nn:ss') Between '08:00:00' And '17:00:00')

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

 

[jkupov]

It Did. Thank you.