This content has been marked as final. Show 3 replies
Vedant wrote:Why are you using a text field for a date column? should you not use a Date Picker item?
I have a date field in my table. On form i have defined text field to enter date into that field entered values like (DDMMYY). its working fine.
Now i have to pass this item value as it is in tabular form corresponding column is date type. It is not accepting the value. How can i pass value of this item into tabular form column as default value.Are you trying to add a default value into tabular form column based on a form item??
i have defined text item as per client requirement , he want to enter date into text field , don't want to use date picker item.
When i do edit to the record ,date display like into the :P1_DATE in format of (DDMMYYYY).
:P1_date item value i want to enter into the tabular form's date column.
when i click on add row button of tabular form then date display into tabular form's date column of :P1_DATE.
Thanks & Regards
Edit your tabular form column > under default section > set the Default Type to PL/SQL Expression or Function > and in Default field add below code
Please consult the documentation and also search the forum first before posting a new question.