APEX

Hi there,

I have a date picker item on a form and need to validate the date to check that it is not in the future and also check the date is in a valid format, as users can type any garbage into the edit box.

I have two validation processes, the first checks for a valid date, a standard apex validation, and the other is a sql validation to check if the date is not in the future.

The validation doesn't appear to work because if i type in any garbarge into the date edit box I get the following

ORA-06503: PL/SQL: Function returned without value
ERR-1023 Unable perform validations.
Return to application.

Any ideas how I can validate a date?

Thanks, Anil