Hi All,
In our application we have created a date picker as below format.
1. Item Name -> P1_ENG_DATE
2. Under Settings-> Format mask->fmDay,Month fmDD,YYYY
3. Under Default value->to_char(sysdate,'fmDay,Month fmDD,YYYY')
4. Once application loads under Date item column we can see date as
5. Now if they select from date picker application will allows to submit form.
6. But if they change date manually i.,e instead of Thursday, if we enter Wednesday, June 18,2015 while submit form it will error as "Error ORA-01861: literal does not match format string" since they are changing day.
7. Not only day change, if we change Wrong Day, Wrong Date and remove last two digits from year we can see literal error problem.
Methods:
1. If we want to make read only option to date picker where we have to do it.
2. How we can handle date picker validation using Java script & PL/SQL.
Could you please help me on this request.
Regards,
Sruthitamiri