4 Replies Latest reply on Jan 22, 2013 7:36 AM by 714270

    How to validate  2 dates in Tabular form

    Pravish-Oracle
      Hello

      I have a tabular form. I have 2 columns end_date and extension_date. I need to create a validation saying " extension_date has to be greater than end_date". I tried below but it didn't worked. Any tips would be helpful.Thanks in advance.

      Validation details

      Column validation,
      Type: Function returning Boolean

      if to_date(:P40_EXTEND_DATE, 'DD-MON-YYYY HH:MIPM') > to_date(:P1_END_DATE, 'DD-MON-YYYY HH:MIPM')
      then
      return true;
      else
      return false;
      end if;