Filter that will capture future date assignments
SummaryI created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific month.
For example.. I need this report to tell me all of the scheduled terms in January 2017, then in Feb tell me all of the schedule terms and the same for March so on and so forth. I need to use this report as a sub-query to another report.
I have headcount report that's scheduled to be delivered the 1st of each month. I plan on using this term report to remove all future terminations for that month. So in Feb when my headcount report is automatically sent it'll have all Feb terminations removed based on this report. Then in March when the headcount report is sent it'll have all March terminations removed based on this report.