Forms [32 Bit] Version 6.0.8.11.3 (Production) , db 10g rel2 , and win 8 ,
i have an text-item of date datatype in my form , it's initial value is $$dbdate$$ , and it's format mask is dd-mm-yyyy
and the item has a when-validate-item trigger which says
if :date_item <> to_date(sysdate,'dd-mm-yyyy')
then
message ('it can not be') ;
end if ;
what happens is it always shows the message even if the :date_item = sysdate or > it or < it .
i do not know why . ?