Query With DD.MM.YYYY Format On A UTCDATETIME Field Does Not Return Any Records (Doc ID 2241736.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 16.7 [IP2016] version, Configuration - General

No records are returned when query with DD.MM.YYYY format.

STEPS
-----------------------
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



Cause

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