Filter to pull employees with anniversaries in the following month
SummaryWe 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.