My Oracle Support Banner

Wrong Date Using Name_in Function (Doc ID 734209.1)

Last updated on AUGUST 14, 2020

Applies to:

Oracle Forms - Version and later
Information in this document applies to any platform.


NAME_IN built-in for date column behaves differently in Forms 6i and 10.1.2.x.
In Forms use:
:block2.b := NVL(NAME_IN('block2.a'),(SYSDATE-3650));

The result in block2.b item will be 12/07/2098 instead of 12/07/1998 in Forms 10.1.2.x
Whereas in Forms 6i it displays the output as 12/07/1998.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.