Tsql >= and <= operators not filtering correctly?
Trying to filter either directly from query or from ssrs and for some reason, the @begindate and @enddate parameters are not including the first and last days.
select * from orders where orderdate >= @begindate AND orderdate <= @enddate
If I choose 09/01/2014 for @begindate and 09/30/2014 as @enddate only the records from 09/02 to 09/29 are included, any orders on 09/01 or 09/30 are not retrieved. I've also tried using between but same results. Am I using the operators incorrectly?