I wrote a query to get data between two dates (SSCE database) in the following way.
Where DTE between @D1 and @D2
it does not work. Then I tried
Where DTE between @#D1# and @#D2#
But it also does not show the data between I gave the dates.
D1 and D2 get dates from two DateTimePickers (formated to short date)