We have a report that we run on the first day of each month, and enter the Start Date and End Date parameters for the dates of the previous month. We want to schedule the report to run on the first day of each month. We can use a date function as the default value for the parameters, but our choices are {$SYSDATE$}, {$FIRST_DAY_OF_MONTH$} and {$LAST_DAY_OF_MONTH$}. I want a function that will give me the first day of the previous month.
SYSDATE - 30 is close but not accurate. I can use FIRST_DAY_OF_MONTH -1 to get the last day of the previous month, but there is nothing to give me my desired start date.
