ADO filtering

[joseluispalma]

Hello friends,

I need to perform a filter in ADO using a date, and it gives me an error:

Code: Select all  Expand view

   cFilter := "HIREDATE >= FW_ValToSQL(DATE())"
   oRs:Filter := cFilter


 

What am I doing wrong?

Thank you and a greeting

[joseluispalma]

I save the filter expresion in a field of the report´s table.

[anserkk]

What about

Code: Select all  Expand view

cFilter := "HIREDATE >= "+FW_ValToSQL( DATE() )
oRs:Filter := cFilter

[joseluispalma]

Thank you, that works, but I need to store the full filter in a database.