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
>csql = "select * from prestacoes where data_venc <= 2006/02/28" >a = SQLEXEC(nID,csql,"resultado") >>