how to add datepicker for a field in apex5.0

Question

i'm new to apex and struggling to add a datepicker on a date field for an interactive report.
How can i add the datepicker or make the field inputable 'DD-MM-YYYY' that will insert into the table and also add validation to make it accept only the system date?
Please help!

What have you tried? What is your code so far? – BeanFrog Mar 20 '17 at 14:59 — BeanFrog, Mar 20 '17 at 14:59
I did The report call another form for input – net Mar 20 '17 at 15:52 — net, Mar 20 '17 at 15:52

kapiell · Accepted Answer · 2017-03-20T23:38:57.357

0

Interactive Reports are not editable in Oracle APEX 5. So, you will have to make use of Tabular Form instead of Interactive Report and then you can add DatePicker column type. You can even add custom validations to tabular forms.

If you are using APEX 5.1, then you can take advantage of Interactive Grid which will let you edit report data and also add validations.

There is a packaged application, "Sample Master Detail" that is shipped with APEX 5 which demonstrates these functionalities. Here are screenshots of the app and the master detail form that has an example of tabular form with editable column with date picker,

edited Mar 20 '17 at 23:38

answered Mar 20 '17 at 15:19

kapiell

697
7
23

Wht sample application are there? – net Mar 20 '17 at 15:53
There are many packaged application but the one that you might be interested in is Sample Master Detail application. I have updated my answers with screenshots of the application. – kapiell Mar 20 '17 at 23:40

score 0 · Answer 2 · answered Mar 21 '17 at 09:15

0

Just add APEX_ITEM.DATE_POPUP in your region select query.

select col1, col2, 
APEX_ITEM.DATE_POPUP(4,rownum,sysdate,'dd-mon-yyyy') hd
from YOUR_TABLE

For more info look at apex documentation: APEX_ITEM.DATE_POPUP

If you need just to format column as input, use html expression in report column properties:

<input type="text" value="#COLUMN_NAME#">

answered Mar 21 '17 at 09:15

Boris Serafimov

607
9
20

Workiing.. txs wht ur email add – net Mar 22 '17 at 17:41
How to add validation in the Datepicker not to enter date < sysdate? – net Mar 25 '17 at 07:34
One option is to format column as input, create dynamic action on page load and use example in this post: [link]http://stackoverflow.com/questions/8356358/jquery-date-picker-disable-past-dates – Boris Serafimov Mar 28 '17 at 08:22

score 0 · Answer 3 · answered Mar 22 '17 at 10:55

0

use the APEX_ITEM.DATE_POPUP2 Property you have get actual date picker

answered Mar 22 '17 at 10:55

Parthiban Oracle Apex

122
1
1
7

thnks wat ur email add? – net Mar 22 '17 at 17:41

how to add datepicker for a field in apex5.0

3 Answers3