2 Replies Latest reply on May 26, 2016 11:33 AM by 3187914

    Form personalisation - exception input




      I want to shhow a message, when the date used is not within the given range. My Original form personalisation works correctly:

      1=(select 1 from dual

      where to_date(:PO_LINES.NEED_BY,'DD-MM-YYYY HH24:MI:SS') NOT between SYSDATE-500 and SYSDATE+30660)


      The problem is that the field is sometimes filled with the text "Multiple" (in case there are multiple dates), that genarates an error massage:

      The Condition could not be evaluates because of error ORA-01858: a non-numeric character was found where a numeric was expected.


      So, I need to make an exception in the input for the text "Multiple". Is this possible and how?