Queries :: Getting Datatype Mismatch Error For Date

I had created a Access DB where there is a query named as "GenerateTimeHours", here whenever am trying to do a search by ID, Time & Date, always getting "data type mismatch error", I checked it and understand this Error is causing for Date Search Clause, I tried every possible way to change the date format, using #, etc etc but no result :Query As follows:

Code:

SELECT GenrateTimeHours.ID, GenrateTimeHours.MaximumSeatsNumber, GenrateTimeHours.DaysInMonth, GenrateTimeHours.Hour, GenrateTimeHours.Remaining, GenrateTimeHours.FinalSeats
FROM GenrateTimeHours
WHERE GenrateTimeHours.ID = 1 and GenrateTimeHours.Hour between #08:00:00 AM# and #10:00:00 AM# AND (GenrateTimeHours.DaysInMonth) between #7/2/2013# AND #7/3/2013#;