The proper statement is:
SELECT *
FROM tbl_Record
WHERE [Date] BETWEEN '2014-09-03' AND '2014-11-03'
Symbols << and > are needed when you omit BETWEEN statement.
SELECT *
FROM tbl_Record
WHERE [Date] >= '2014-09-03' AND [Date] <= '2014-11-03'
Both queries are equal.
Note:
Do not use such of queries. Use
stored procedured[
^] instead.