My Oracle Support Banner

Open UI: Wrong Conversion of Date Field when Using Custom Display Format DD-MMM-YYYY (Doc ID 2549155.1)

Last updated on OCTOBER 24, 2019

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Symptoms


The following issue was reported by customer after going with Open UI, and while  using a custom display format for some date list columns: DD-MMM-YYYY.


ACTUAL BEHAVIOR
---------------
When user enters '11/1/2019' , the date is converted to  01-Nov-2019

When user enters 13/1/2019' ,  this is converted to   13-Jan-2019

EXPECTED BEHAVIOR
-----------------------

Conversion of the date field should be consistent. In customer case one time date is converted as MM-DD-YYYY , the second date is converted as DD-MM-YYYY

STEPS
-----------------------

1. Open Tools and create a workspace.
2. Select "Activity List Applet with Navigation" applet and change the display format for Planned list column to  DD-MMM-YYYY
3. Deliver the workspace and start a new application session
4. Navigate to Activities ( Activity List Applet with Navigation ) and create a new activity record
5. Set Planned start to '11/1/2019'  => this is converted to  01-Nov-2019 when stepping of the field
6. Set the Planned start to '13/1/2019' => this is converted to   13-Jan-2019


The issue is reproducible only when customizing the display format.

In standard  when creating an activity and setting start date to "13/1/2019" an error occurs as expected: ""13/1/2020": Can't convert formatted string to its internal representation.  Check if your data is in correct format"



Changes

1. Open Tools and create a workspace.
2. Select "Activity List Applet with Navigation" applet and change the display format for Planned list column to  DD-MMM-YYYY
3. Deliver the workspace and start a new application session

 

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
References


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