There are several ways to achieve that. Please, see below examples:
SELECT *
FROM TableName
WHERE FromDate BETWEEN @dateFrom AND @dateTo
SELECT *
FROM TableName
WHERE ToDate BETWEEN @dateFrom AND @dateTo
SELECT *
FROM TableName
WHERE Submitdate BETWEEN @dateFrom AND @dateTo
SELECT *
FROM TableName
WHERE FromDate>= @dateFrom AND SubmitDate <=@dateTo
[EDIT #1]
If you want to get date difference, use
DATEDIFF[
^] function or
CONVERT[
^] function to substract date diffs as integer.
SELECT *
FROM TableName
WHERE DATEDIFF(dd, FromDate, ToDate)<=2
SELECT *
FROM TableName
WHERE CONVERT(INT, FromDate - ToDate)<=2
[/EDIT]