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 SIA [16061] and later
z*OBSOLETE: Microsoft Windows 2000
Version: [16061] Life Sci

Database: Oracle

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.


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?




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
 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.