2 Replies Latest reply on Sep 5, 2013 2:38 PM by Iwawa

    Conditional format


      Hi to all,

      I Have created a report with report Builder. In this report I have a lot of fields; but my interest is for two of them:

      1) the first field is FLD_CURRENT_DATE with origin Current Date

      2) the second field is FLD_EXPIRATION_DATE with origin Database->EXPIRATION_DATE

      Now I need to compare the 2 date and print with red colour the field FLD_EXPIRATION_DATE if  <= FLD_CURRENT_DATE.

      I have tried to use the conditional formatting, inserting this code (:EXPIRATION_DATE <= 'FLD_EXPIRATION_DATE'), but the statment is, obviously, not correct and the following errors are returned during compilation:

      REP-1401: '': Fatal PL/SQL error occurred

      ORA-01858: a non-numeric character was found where a numeric was expected

      Can I get some help?