MINIMUM DATE AND MAXIMUM DATE FOR A DATE PICKER IN A TABULAR FORM

MINIMUM DATE:

The Minimum date can be set for a date picker in the tabular form using the following steps.

1. Set SYSDATE as the source value to an item Using PLSQL Function Body.

Using the following code

BEGIN

RETURN SYSDATE;

END;

Go to EDIT PAGE-> JAVASCRIPT->Execute when page load

 Then, set this date to the required column Using this code below

$("td[headers='COLUMN_NAME'] input")

.datepicker("option","changeMonth",false)

.datepicker("option","minDate",$v("ITEM NAME"));

EX:

$("td[headers='DEACTIVATION_DATE'] input")

.datepicker("option","changeMonth",false)

.datepicker("option","minDate",$v("P16_SYSDATE"));

MAXIMUM DATE:

The Maximum date can be set for a date picker in the tabular form Similar to the above mentioned steps.

Only change is that

Go to EDIT PAGE-> JAVASCRIPT->Execute when page load

 Then, set this date to the required column Using this code below

$("td[headers='COLUMN_NAME'] input")

.datepicker("option","changeMonth",false)

.datepicker("option","maxDate",$v("ITEM NAME"));

By

Angel