Is there a supported approach to display only the date (without the timestamp) in the Infolet Detail
in Sales
Summary:
Problem Statement
I have created an OTBI report in Oracle Sales Cloud where the Creation Date column is formatted as MM/DD/YYYY without a timestamp. When I run the report directly in OTBI, the date displays correctly (e.g., 05/24/2026).
However, when the same report is exposed as a Detailed Report from an Infolet, the Creation Date is displayed using the user's regional format and includes a timestamp (e.g., 24/5/26 12:34 PM).
I have already tried:
- Setting a custom column format (
MM/DD/YYYY) in OTBI. - Using
CAST("Service Request"."Creation Date" AS CHAR), which returns2026-05-24 07:04:01.000000. - Using
TO_CHAR
0