My Oracle Support Banner

Searching Data In The Date Field From UI Gives Wrong Result (Doc ID 2641370.1)

Last updated on FEBRUARY 26, 2020

Applies to:

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



Searching for records using script with criteria on Date field giving incorrect results

instead of giving the results in between the provide date criteria date and time stamp it is returning whole day records

The issue can be reproduced at will with the following steps:

Sample Script used :-

2. use this logic to make query on UTC Date time fields in script

example :- SetSearchExpr("[Created] <= '" + todaytime  + "' AND [Created] >= '" + xyz + "'");

in this case it is returning whole day records created on Nov 2nd 2019


3. to simplify the test case performed the same scenario from UI as  below

Searching data in the date field from UI gives wrong result


When in the user interface if search for results using below query return records from whole day instead of giving the records which got created in between 7:35:59 and 9:35:59.


[Created] <= '11/28/2019 9:35:59' AND [Created] >= '11/28/2019 7:35:59'


whereas if I search using below query system returns correct data.


[Created] <= '12/16/2019 13:00:00' AND [Created] >= '12/16/2019 13: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.