2 Replies Latest reply: Sep 5, 2013 9:38 AM by Iwawa RSS

    Conditional format

    Iwawa

      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?