TRANSIT DAY Count

 

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