Hi Varelafpy,
First point, SELECT statements are not really expected into the Action Rules tab as a result set is generated for update.
Try the test from the data tab.
Afaik "date" is a SQL built-in function for Ingres, so the query appears to me as valid.
If you did not already do then check that "select date('Now')" query works fine from the native Ingres interactive SQL console, connected to your database.
Please also test "select date('now')" instead of "select date('Now')".
Going further will imply for me that I get an Ingres server to test.
Regards,
Philippe.