I saw that you found a solution already but I think it is worth to give an explanation on what is happening.
The
Date
column from your table is probably a
DateTime
containing date and time. If you use a date without time in your query, the time portion is implicitly set to 00:00:00. So the effective query will be
select * From Table where Date BETWEEN '23/3/2016 00:00:00' AND '23/3/2016 00:00:00'
This applies also when using a comparison rather
BETWEEN
.
So there are two common solutions:
Use
BETWEEN
with time for end date:
select * From Table where Date BETWEEN '23/3/2016' AND '23/3/2016 23:59:59.999'
Or use less than comparison for the end date with the following day:
select * From Table where Date >= '23/3/2016' AND Date < '24/3/2016'