Date Prompt in Direct DB Request
Hi
I have to pass the below filter in Direct Database Request but
when I do as Filter in Report its working good
T522452.ORDERED_DATE =EVALUATE('TO_DATE(%1,%2)', '@{Date1}','MM/DD/YYYY HH:MI:SS AM')
but when I give the same sql in Direct db request its throwing an error
Oracle Error code: 29900, message: ORA-29900: operator binding does not exist ORA-06553: PLS-306: wrong number or types of arguments in call to 'EVALUATE' at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed.
Please let me know what I have to do
Summary
I am trying to pass Pv from prompt(Date Fx: cast(Column as date) to Direct DB Request.
Thanks