Wrong Date Using Name_in Function
(Doc ID 734209.1)
Last updated on AUGUST 14, 2020
Applies to:Oracle Forms - Version 10.1.2.3.0 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