Hello i trying to get some results from my tables between 2 dates using VB 6 adn SQL Server 2000.

i wrote the following query for this
Code:
MDateQry = " BETWEEN '" & TxtDtFrom & "' And '" & TxtDtTo & "'"

RsGlt.Open "Select Code,Tdate from glt where Code = " & RsDrt.Fields("Code") & "  and tDate" & MDateQry, Cn, adOpenStatic, adLockOptimistic
but ig gives the error :

[Microsoft][odbc sql server driver][sql server] The Conversion of a char Data type to a datetime data type resulted in a out-of-range date time value.

What is this problem?
Please help me