"WHERE Date LIKE @Date" doesn't make any sense. LIKE is a string comparison operator, and if you attempt to use it on dates, you can get unexpected results, as you've seen. Use "=" instead. If the date is stored or specified with a time portion but you only want to compare the date portions, convert to a date-only format before doing the comparison. By the way, dd/mm/(yy)yy is an ambiguous format - try to use yyyymmdd instead.