4 Replies Latest reply on Aug 7, 2014 4:35 PM by Orv-Oracle

    To_Date shows error at report

    Orv-Oracle

      Hi guys

       

      I am using the following query to create a data model and a report to query the data model :

       

      SELECT

      ILDOC

      ,ILDOCO

      ,ILDCT

      ,ILKCO

      ,to_date(1900000 + ILTRDJ, 'yyyyddd')

      ,ILMCU

      ,ILTRQT

      ,ILTRUM

      ,ILDCTO

      ,ILUNCS

      ,ILPAID

      ,ILLOTN

      ,ILLOCN

      ,ILLOTS

      ,ILLOTG

      ,ILLOTP

      ,ILKCOO

      ,ILGLPT

      ,to_date(1900000 + ILDGL, 'yyyyddd')

      ,ILTREX

      FROM

          F4111

       

       

      But the data is not displayed and the message " An error ocurred "is displayed, this is due to the TO_DATE Function because when I only use the column the error is not showed.

       

      How can I solve this?