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 in OTBI to show data as of end of previous month

Received Response


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.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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