I am using Apex 18.2 and created a master detail form (side by side) every thing working fine, in the master table there are 3 columns
1. SALE_DATE DATE (Date picker)
2. BERT_DATE DATE (Date picker)
3. Difference Number(5)
I want sale_date - bert_date = difference so I created a Dynamic action on change event at SALE_BERT.
and set value PL/SQL Function body return ( TRUNC(:P36_Sale_date) - TRUNC(:P36_Bert_date) );
Item to Submit P36_BERT_DATE,P36_SALE_DATE
Affected elements P36_Difference
when I run page and enter value on SALE_DATE showing the error Ajax call returned server error ORA-06502. PL/SQL Numeric or Value error.
Please guide how to get days between two dates in oracle apex.