Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Expression Filters (Dynamic Date Ranges)

Accepted answer
103
Views
1
Comments
Kelvin007
Kelvin007 Rank 1 - Community Starter
edited Aug 13, 2024 7:42PM in Oracle Fusion AI Data Platform Forum

Hi,

does anyone know if it is possible to create expression filter with dynamic date ranges in FAW?

i am trying to create a filter that only shows the "last 12 months", "last 6 months" .. etc from the current date.

any guidance would be much appreciated, thanks

Tagged:

Best Answer

  • Caroline Blanchard
    Caroline Blanchard Rank 6 - Analytics & AI Lead
    Answer ✓

    Hello, not sure if this has been answered by now, but have you seen the relative time feature in either fiscal date or date fields?

    image.png

    I'm sure you could also create an expression filter using 'timestampdiff' with current date if you want to do it manually. Hope this helps!