My Oracle Support Banner

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 later
Information in this document applies to any platform.


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?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.