Data Is Not Format When Using Max Aggregate Function In RTF Template
(Doc ID 2750842.1)
Last updated on FEBRUARY 09, 2021
Applies to:
BI Publisher (formerly XML Publisher) - Version 12c and laterInformation in this document applies to any platform.
Goal
On : 12c version, Designing Layout Templates
Customer created an RTF template and the requirement is to display the max date within the group. Max aggregate function can be applied when field is "Regular Text" and not when its "Date". Issue is that after applying the max function can not format value in any date format.
Required date format is 'MM/dd/yyyy' but value is displayed as yyyMMdd.
How to get max Date within a group with specific Format?
Solution
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
Goal |
Solution |
References |