This discussion is archived
2 Replies Latest reply: Sep 5, 2013 7:38 AM by Nick2005 RSS

Conditional format

Nick2005 Newbie
Currently Being Moderated

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?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points