The following select code is utilized to filter a gridview date range search. It is working; however, if I perform a singe date range search for example: 9/16/13 through 9/16/13 it will not return the 9/16/13 data. If I open up the search one day to 9/17/13 it will display the 9/16/13 data and not the 9/17/13 data and so on. I have tried using >= and <= but getting the same result as the between function.
SelectCommand="SELECT [ID], [Dates], [Ship], [Station], [Otbd], [Dep], [Code], [Time], [Code1], [Time1], [Wake], [Call], [MM], [RB], [Reason], [ATA], [RON], [GT], [Captain] FROM [Delays] WHERE [Dates] between @Dates and @Dates2 AND [Dep] between @Dep and @Dep2 AND [Station] = @Station AND [Code] IN ('MC', 'MM', 'MA', 'MF', 'MH', 'ML', 'MN') ORDER BY [Dates] DESC"