Thursday 29 December 2016

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

No comments:

Post a Comment