Create Dynamic Action on "P99_2ND_DAY" & "P99_3RD_DAY" item
Action : Set Value
Set Type : PL/SQL Function Body
if :P99_3RD_DAY is null then
return to_date(:P99_2ND_DAY,'DD-MM-RR') - to_date(:P99_1ST_DAY,'DD-MM-RR') ;
else
return to_date(:P99_3RD_DAY,'DD-MM-RR') -to_date(:P99_1ST_DAY,'DD-MM-RR') ;
end if ;
Items to Submit : P99_1ST_DAY,P99_2ND_DAY,P99_3RD_DAY
Affected Elements : P99_TOTAL_TRANSIT_DAY
Tags:
Oracle Apex (ix)