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

    Using Minimun Date attribute in items Displayed as Date Picker

    Lecc23

      Hi,

       

      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..

      Example

      200906110000

      +1m+1y+1w

      -1m-1w

      +1m-1d

      &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!

       

      Thanks,

      Luis