My Oracle Support Banner

Using text in DTYPE_DATE field not formating correctly (Doc ID 508296.1)

Last updated on JANUARY 01, 2020

Applies to:

Siebel CRM - Version 7.5.2.211 SIA [16061] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.5.2.211 [16061] Life Sci

Database: Oracle 9.0.1.3

Application Server OS: Microsoft Windows 2000 Server SP 3

Database Server OS: Microsoft Windows 2000 Server SP 3



This document was previously published as Siebel SR 38-1095252831.

Symptoms

When users enter a value in the Birth Date field in the Contact BC such as "November 23, 1975" the value returned in date format is 12/19/1975. If the user enters September 14, 1945 the date is returned as "12/19/2045". This was also tested againt vanilla Siebel with the same results.

Is there a workaround for this behaviour without using script?


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Message 1

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