BI Publisher (MOSC)

MOSC Banner

Incrementing Date Parameters

edited Mar 20, 2020 8:50PM in BI Publisher (MOSC) 12 commentsAnswered ✓

Hello there,

When creating BI Publisher reports this is a known parameter value {$SYSDATE()$} - if you enter this, it will launch the report each time with current date as the parameter. Also this works just fine {$FIRST_DAY_OF_MONTH()$} - first day of the current month; but is there a way to set a parameter to always use the first day of PREVIOUS month as start date and last day of PREVIOUS month as the end date please?

THanks Alica

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center