Hi Jeck,
We do not have the support for checking the times with dates using the Between operator. A feature request is registered.
Link to the feature request
To handle this problem now, instead of using RecordFilters, you can subscribe to the QueryRecordMeetsFilterCriteria event and handle the testing requirement for whatever conditions you want. Here is a
little sample.
Best regards,
Stanley