Data type mismatch in Query

[Brianwarnock]

They are correct if they are start and end times in that order, I suspect that the dates are not equal and thus the times go over midnight, obviously those records would not be selected if the Where clause worked.

Brian

 

[Brianwarnock]

Have you tried removing the Datediff from the where clause to confirm that is where the problem is.

Brian