Query With DD.MM.YYYY Format On A UTCDATETIME Field Does Not Return Any Records
Last updated on MARCH 08, 2017
Applies to:Siebel CRM - Version 16.7 [IP2016] and later
Information in this document applies to any platform.
On : 16.7 [IP2016] version, Configuration - General
No records are returned when query with DD.MM.YYYY format.
The issue can be reproduced at will with the following steps:
1. Navigate to Invoice entity
2. Field with UTC date time format present in Invoice entity.
3. Field display date in dd.mm.yyyy format.
4. Query on the field with dd.mm.yyyy format
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