Query by Date Brings Datetime Format in Open UI

(Doc ID 1601542.1)

Last updated on MARCH 21, 2017

Applies to:

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


Starting with Open UI, when query by a date field, the date picker returns
datetime format. This limit the result set to that specific datetime.


  1. Log into Open UI.
  2. Navigate to Service > All Service Requests.
  3. Click Query button.
  4. Enter 12/12/2016 in "Date Opened" or any other date field.
  5. Tab out of the field.
  6. The date now incorrectly updates to "12/12/2016 12:00:00 AM"; thus, the query is executed against "12/12/2016 12:00:00 AM".





Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms