You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)

Received Response


Hi Forum:

I'm looking to use below to accomplish General tab for Scheduling a report

START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day

END: Last_Day(ADD_MONTHS(SYSDATE,-1)) Last_day

using below:

  • {$SYSDATE()$} - current date, the system date of the server on which BI Publisher is running.
  • {$FIRST_DAY_OF_MONTH()$} - first day of the current month
  • {$LAST_DAY_OF_MONTH()$} - last day of the current month
  • {$FIRST_DAY_OF_YEAR)$} - first day of the current year
  • {$LAST_DAY_OF_YEAR)$} - last day of the current year

Appreciate any tips to

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!