2 Replies Latest reply on Jul 24, 2015 12:52 PM by Ebin

    OBIEE Evaluate function error

    user13816768

      Hi -

      Can you please help me in solving the below formula?

       

      TimestampDiff(SQL_TSI_DAY, "Fact Work Item"."System Created Date" , cast( LEFT( '@{last_pv}' ,4 ) || '/' || SUBSTRING( '@{last_pv}' FROM 6 FOR 2) || '/' || SUBSTRING( '@{last_pv}' FROM 9 FOR 2)||' 00:00:00' as date))

       

       

      the following is the error message:

       

      Message returned from OBIS. [nQSError: 17001] Oracle Error code: 1858, message: ORA-01858: a non-numeric character was found where a numeric was expected at OCI call OCIStmtExecute:

       

       

      Thanks!