APEX

Hi All,

I am working with oracle apex 4.2.

I recently encountered a problem while saving a form.

I have a database column named DOC_DATE and I set default value as trunc(sysdate).

In apex the date column appears with the format mask 'DD-MON-YYYY'.

When I save the record by hitting 'CREATE' button the following error is displayed

Doc Date does not match format YYYY-MM-DD.

Then I have changed my application date format to 'DD/MM/YYYY'.

And I have added an Application Process with the following query

execute immediate 'alter session set nls_date_format=''dd/mm/yyyy''';

Now the DOC_DATE field displayed with the format mask 'DD/MM/YYYY'.

But again when i click create the same error comes.

Any help will be greatly appreciated.

NOTE - my nls_date_format is dd-mm-yyyy

Regards,

Soofi