My Oracle Support Banner

Date Format Getting Changed While Querying In IP 2018 (Doc ID 2500097.1)

Last updated on JULY 05, 2020

Applies to:

Siebel CRM - Version 18.8 and later
Information in this document applies to any platform.


When user is querying in date field , date picker picks date in DD/MM format and shows in UI (before querying). But while user queries, it fetches in MM/DD format. Expectation result is that Application should query for the records in proper date format and return correct set of results.

Navigate to Administration - Date---->Locale and set the following values for ENU language:

24 hour clock: TRUE
Short Date: M/d/YYYY

2. Navigate to Administration - System Preference.
3. Query for "Strict Date Format" and set the value to "DD/MM/YYYY"
4. Restart application server

5. Navigate to Service Request list view and expose "Committed" field
6. Create two records by setting the date value to "07/09/2018 00:00:00"
7. Query for the same record by entering "07/09/2018 00:00:00".
8 No record will be retrieved even though the records with the given date
are available
9. Review the logs and notice that instead of querying for "07/09/2018
00:00:00", application is querying for "09/07/2018 00:00:00"




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.