nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Expression Filter to Filter to MAX Date

JobDeLuna

Hi,

Request any help the possibility for an expression filter to filter to the MAX Date.

"SCST - Savings Impact Reporting"."Time"."Snapshot Date"

Find more posts tagged with

Data Preparation and Flows

Filters

Fusion Data Intelligence

Calculation

Fusion AI Data Platform

Accepted answers

Jestin Rajan

https://community.oracle.com/products/oracleanalytics/discussion/27214/expression-filter-to-filter-to-max-date

Hi,

You can use the TOPN function to get the MAX date. It should do the trick!

TOPN(CAST("SCST - Savings Impact Reporting"."Time"."Snapshot Date" AS DATE), 1) = 1

Let me know if you face any challenges while implementing it.

All comments

Jestin Rajan

https://community.oracle.com/products/oracleanalytics/discussion/27214/expression-filter-to-filter-to-max-date

Hi,

You can use the TOPN function to get the MAX date. It should do the trick!

TOPN(CAST("SCST - Savings Impact Reporting"."Time"."Snapshot Date" AS DATE), 1) = 1

Let me know if you face any challenges while implementing it.

JobDeLuna

Thanks @Jestin Rajan !!! It worked

Jestin Rajan

Happy to help! 😊

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders