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