Assuming by "middle of fromdate and todate" you mean between fromdate and todate then the following statement will work to select a range of values between two dates:
SELECT * FROM mydatetable WHERE datefield BETWEEN @fromdate AND @todate
This is making use the
BETWEEN
operator.
The MSDN article for this operator can be found here:
http://msdn.microsoft.com/en-us/library/ms187922.aspx[
^]