Termination report with subquery
Summary
Looking for a subquery that would eliminate currently active employees form termination reportContent
Hello,
I am trying to build a termination report for our organization that at run-time would show all currently inactive employees who were terminated 20 days ago. Currently the report pulls ALL employees who were terminated 20 days ago, even if they have been rehired since, and their current status is active - the report just pulls their historical termination record.
Does anyone know how I could build a subquery that would eliminate anyone who has been terminated 20 days ago but is currently active in the system?