2 Replies Latest reply on Dec 10, 2013 7:47 PM by Lecc23

    Using Minimun Date attribute in items Displayed as Date Picker




      Working in a FORM, it has two items (Diasplay as Date Picker). THey are DATE OF ACTIVITY ( item name: P12_F_CARGA) and DATE OF APPROVAL (item name: P12_F_APROBACION). Now, DATE OF APPROVAL must be >= than DATE OF ACTIVITY.


      -For both items: Format Mask:DD-MON-YYYY

      -For item DATE OF APPROVAL:Minimun Date: &P12_F_CARGA.


      According to documentation Minimun Date is a minimun selectable date and The value can be absolute value in YYYYMMDDHH24MI format or relative value with respect to today's date e.g. +7d  ('y' for years, 'm' for months, 'w' for weeks, 'd' for days) or name of the item, which holds the value e.g. &ITEM_NAME..






      &ITEM_NAME. (including period)



      The message received is:


      Introduzca el valor de atributo de fecha mínimo 22-NOV-13 para el elemento P12_F_APROBACION que no coincide con el formato YYYYMMDDHH24MI.

      ORA-01858: se ha encontrado un carácter no numérico donde se esperaba uno numérico


      Tecnical Information (Only for Developers)

      • is_internal_error: true
      • apex_error_code: DATEPICKER.MIN_DATE_INVALID
      • ora_sqlcode: -1858
      • ora_sqlerrm: ORA-01858: Oracle has found an non numeric character where a numeric was expected.
      • component.type: APEX_APPLICATION_PAGE_ITEMS
      • component.id: 3691021571424602
      • component.name: P12_F_APROBACION
      • error_backtrace:ORA-06512: en "APEX_040100.WWV_FLOW_UTILITIES", línea 10551




      PD: I tested using +1d and 201211220000 and it works!