DATE_POPUP2 Function

Use this function with forms that include date fields. The DATE_POPUP2 function dynamically generates a date field that has a jQuery based popup calendar with button.

Syntax

APEX_ITEM.DATE_POPUP2 (
    p_idx                   IN NUMBER,
    p_value                 IN DATE     DEFAULT NULL,
    p_date_format           IN VARCHAR2 DEFAULT NULL,
    p_size                  IN NUMBER   DEFAULT 20,
    p_maxLength             IN NUMBER   DEFAULT 2000,
    p_attributes            IN VARCHAR2 DEFAULT NULL,
    p_item_id               IN VARCHAR2 DEFAULT NULL,
    p_item_label            IN VARCHAR2 DEFAULT NULL,
    p_default_value         IN VARCHAR2 DEFAULT NULL,
    p_max_value             IN VARCHAR2 DEFAULT NULL,
    p_min_value             IN VARCHAR2 DEFAULT NULL,
    p_show_on               IN VARCHAR2 DEFAULT 'button',
    p_number_of_months      IN VARCHAR2 DEFAULT NULL,
    p_navigation_list_for   IN VARCHAR2 DEFAULT 'none',
    p_year_range            IN VARCHAR2 DEFAULT NULL,
    p_validation_date       IN VARCHAR2 DEFAULT NULL )
    RETURN VARCHAR2;

Parameters

Parameter	Description
`p_idx`	Number that determines which APEX_APPLICATION global variable is used. Valid range of values is 1 to 50. For example, 1 creates F01 and 2 creates F02.
`p_value`	Value of a field item.
`p_date_format`	Valid database date format.
`p_size`	Controls HTML tag attributes (such as disabled).
`p_maxlength`	Determines the maximum number of enterable characters. Becomes the maxlength attribute of the `<input>` HTML tag.
`p_attributes`	Extra HTML parameters you want to add.
`p_item_id`	HTML attribute ID for the `<input>` tag.
`p_item_label`	Invisible label created for the item.
`p_default_value`	The default date which should be selected in datepicker calendar popup.
`p_max_value`	The Maximum date that can be selected from the datepicker.
`p_min_value`	The Minimum date that can be selected from the datepicker.
`p_show_on`	Determines when the datepicker displays, on button click or on focus of the item or both.
`p_number_of_months`	Determines number of months displayed. Value should be in this array format: `[row,column]`
`p_navigation_list_for`	Determines if a select list is displayed for Changing Month, Year, or Both. Possible values include: `MONTH`, `YEAR`, `MONTH_AND_YEAR`. Default NULL.
`p_year_range`	The range of years displayed in the year selection list.
`p_validation_date`	Used to store the Date value for the which date validation failed.