Hi Experts,
I need to find the users Mitigated on a Particluar date and in a month for Audit Purpose.
As there is no Change Document to check this in RAR 5.3, i am forced to turn to Ccdebugger.
While i have used the SQL query for simple executions, i am faced with a problem VIRSA_CC_MITUSER table using date format.
When i use query
select * from VIRSA_CC_MITUSER where validfrom=('2011-12-02')
i get the error
"ErrorThe SQL statement "SELECT * FROM "VIRSA_CC_MITUSER" WHERE "VALIDFROM" = '2012-01-12'" contains the semantics error[s]: - 1:38 - type check error: the left hand side >>"VALIDFROM"<< (DATE) and the right hand side >>'2012-01-12'<< (CHAR) of a comparison operator are not comparable "
Help is appreciated. I know this query would sound silly to you experts, but i am struggling with this for the past few days and time is running out.
With Regards,
Ganesh.S