If
[Date]
field is a datetime type, you don't need to convert it as a string (varchar).
SELECT *
FROM RechargeReport
WHERE [Date] BETWEEN '01/04/2013' AND '24/04/2013'
If you want to convert
[Date]
string (varchar), you need to do that as follow:
SELECT *
FROM RechargeReport
WHERE CONVERT(VARCHAR(10),[Date],103) BETWEEN '01/04/2013' AND '24/04/2013'
In case of converting error, see this:
SET DATEFORMAT[
^]