2 Replies Latest reply on Oct 22, 2018 11:08 PM by Usman Ali

    Employee Head Count

    Usman Ali

      I have emp#, Hire_Date and Termination_date.

       

      I want to count each employee every year starting from hire_date till his termination_date year comes.

       

      For example.

       

      If emp# 100 have hire_date 01/01/2013 and his termination_date is 31/12/2017. The this employee should be count =1 in year 2012,13,14,15,16,17.

       

      And if any employee have hire_date and termination_date in same year then he should not be counted.

       

      Regards,

       

      Usman