Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)
Summary:
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
Tagged:
0