You can create PL/SQL validation to compare the date with sysdate before submitting the form.
Type: Function Returning Error Text
if to_date(:P1_DATE,'DD-MON-YYYY') <trunc(sysdate) then
return 'Date should be greater than Today's Date';
Create validation like this,
Type: Function Returning Error Textbegin if to_date(:P3_RELEASING_DATE,'DD-MON-YYYY') < to_date(sysdate,'DD-MON-YYYY') then return 'Releasing Date should be greater than today Date'; else return null; end if; end;
sysdate is a date value. Never apply
to_date conversion to values that are already of
This is an answered thread but I need point out that SYSDATE is already type DATE. So if this is to work
there must be an implicit conversion from DATE to CHAR before TO_DATE can be applied. Maybe it's smart enough to optimize all the unnecessary conversion out. ??
I presume TRUNC(SYSDATE) is what is really needed. And that is of type DATE as well. So I think this is what is needed -
to_date(:P3_RELEASING_DATE,'DD-MON-YYYY') < TRUNC(SYSDATE)