6 Replies Latest reply: Mar 15, 2013 9:09 AM by Srini VEERAVALLI RSS

    OBIEE 11G

      Client wants to filter by current date......

      "Discharge Date"."CAL_DT" = (current_date-40) but this gives error.....
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type. (HY000)

      when they change it to "Account Discharge Date"."CAL_DT" >= (current_date-40) it gives results. Not sure what they are trying to do. How can I alter the first filter to get it to work?

      Please advise