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

Filter to pull employees with anniversaries in the following month

Received Response
edited Jul 9, 2018 10:41PM in Reporting and Analytics for HCM 6 comments


We need to build a report that is emailed monthly and pulls any employees that have service anniversaries in the following month


We need to create a report including employees with upcoming service anniversaries. The report needs to be set up as an agent that is emailed on a monthly basis. The report should only pull employees that have anniversaries in the following month. For example if the SYS DATE = June 5, 2018 then the report should pull employees with anniversaries in July. Any ideas on how to create this filter in OTBI? We don't want to use BIP.


Howdy, Stranger!

Log In

To view full details, sign in.


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