Report in OTBI to show data as of end of previous month
Need to show number of openings (from recruiting requisitions) from a specific date (6/1/22) through the last day of the previous month. I created a filter to show openings for all reqs opened between 6/1/22 and TIMESTAMPADD(SQL_TSI_DAY, DAYOFMONTH(CURRENT_DATE)* -(1) + 1, CURRENT_DATE), but this is live information as of today (12/14), rather than the actual number of openings as of 11/30, as some have likely since been filled between 11/30 and today.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):