pravish wrote:You can use the apex_application.g_fxx arrays instead of using bind variables in the validation code. To identify which apex_application.g_fxx arrays map to your date columns, you need to look at the generated HTML source of the page or refer to this link for details:
I have a tabular form. I have 2 columns end_date and extension_date. I need to create a validation saying " extension_date has to be greater than end_date". I tried below but it didn't worked. Any tips would be helpful.Thanks in advance.
Type: Function returning Boolean
if to_date(:P40_EXTEND_DATE, 'DD-MON-YYYY HH:MIPM') > to_date(:P1_END_DATE, 'DD-MON-YYYY HH:MIPM')