You can use
DATEDIFF
[
^] in your
WHERE
clause.
To compare on the same day use
SELECT * FROM tblSale WHERE DATEDIFF(day,salesDate,@SELECTEDDATE)=0
To compare on the same month use
SELECT * FROM tblSale WHERE DATEDIFF(month,salesDate,@SELECTEDDATE)=0
To compare on the same year use
SELECT * FROM tblSale WHERE DATEDIFF(year,salesDate,@SELECTEDDATE)=0