i have 2 datetime fields OnDateTime, OfDateTime
OnDateTime 2012-04-02 18:00:00
OffDateTime 2012-12-01 23:00:00
the query needs to return data between the dates but only between 18:00:00 -23:00:00 every day between the 2 dates. i'e it should not return anything if query is run 2012-04-03 16:00:00 but it is to return data if query is run 2012-04-03 18:01:00. for now i'm dealing with this programatically but i would like to use a query for it.