Hi,
Apex Version 4.2.6
The end_date should be greater than the start_date .....I'm not getting expected result in this validation...
BEGIN
FOR i IN 1 .. apex_application.g_f07.COUNT
LOOP
IF TO_DATE (apex_application.g_f06(i), 'DD-MON-RR') <
TO_DATE (apex_application.g_f07(i), 'DD-MON-RR')
THEN
NULL;
ELSE
RETURN '<font size = 3 color = "Red">End Date should be greater than Start Date</font>';
END IF;
END LOOP;
END;
Thanks
Infantraj