Sergey,
If I run those statements:

csql = "select * from prestacoes where data_venc >= '2005/09/23'"
csql = "select * from prestacoes where data_venc <= '2006/02/28'"

It returns this message:
"The conversion of char data type to smalldetime data type resulted in an out-of-range smalldatetime value"

How to solve this problem now ?

Peter


>Peter,
>
>The SQL Server can accept date constand either as string or as numeric value. You first select is equivalent to

csql = "select * from prestacoes where data_venc >= 9"
>* which is the same as
>csql = "select * from prestacoes where data_venc >= '1900-01-10'

You would want to pass dates as string literals

csql = "select * from prestacoes where data_venc >= '2005/09/23'"
>csql = "select * from prestacoes where data_venc <= '2006/02/28'"
>

>
>
>>Hi, it's friday and I'm going crazy with a simple SQL statement.
>>

>>csql = "select * from prestacoes where data_venc >= 2005/09/23"
>>a = SQLEXEC(nID,csql,"resultado")
>>

>>returns the data from SQL server as expected
>>But, if I run this one:
>>

>>csql = "select * from prestacoes where data_venc <= 2006/02/28"
>>a = SQLEXEC(nID,csql,"resultado")
>>

>>
>>Returns no record
>>
>>But if I run those same statements in QA, I get the data as expected in both cases.
>>Why when I use "< " ou "< =" I dont get those values that exist in table prestacoes.
>>