Hi,
I currently have a dynamic action on a date column with a date picker where if the expiration date is greater than the sysdate, then it sets the value to the status column as either valid or expired.
No value is being input in my status column.
I'm not sure if the selected date is being referenced correctly.
Any help would be greatly appreciated
begin
if
To_date(:P3_DATE_EXPIRED, 'DD-MON-RR') < trunc(sysdate)
then
return 'Expired';
elsif
To_date(:P3_DATE_EXPIRED, 'DD-MON-RR') > trunc(sysdate)
then
return 'Valid';
end if;
end;