I am having issues with a reporting request which I was hoping the group could assist with. I need to derive a count of active employees by month based on their hire and termination date. I don't want to count partial workers so an employee would need to be active at the company for the entire month and excluded if they were hired or terminated some time during that reporting month. I have tried converting the hire and termination dates in to a month-year format, but am getting caught up with identifying which employees fall in or out of that reporting period and how to count results. Any assistance or suggestions would be greatly appreciated.
