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.
TIA
Peter