1 Reply Latest reply on Oct 26, 2018 3:07 AM by Aman Singh

    Find Consecutive Date Logic

    Aman Singh

      Hi All,

       

      I have scenario in which i need to find out 11 consecutive dates by Employees.

       

      Let me explain in details -

      If a employee have 11 consecutive date then count as 1. And check for next 11 consecutive. Only the case of 11 consecutive date, it should be 1.

      I want the final result in Employee with their count. if i see result in quarter wise, count should not be greater than 9 for each employee.

       

      Hope you understand.

       

      Regards,

      Aman