Your string is not formatted correctly should be more like the following.

Code:
(EventTime >= #6:00:00 AM#  AND EventTime <=  #1:00:00 PM#)