3 Replies Latest reply: Sep 29, 2011 7:41 AM by Michiel van de Goor RSS

    Latest date per employee per indicator

      Hi there,


      Trying to make an overview for holidays per employee. Running into the following problem:


      Regulations are in the sp_indicator table but different per employee. The valid from date differs as users may be later on the payroll than start of the year.

      As I try to make a list of remaining holidays from last year or holidays for contractual rights the indicator type is different from the indicator_type_id field. To get the correct data I used the If statement in the overview table... however, I need a latest date per employee for each indicator type.


      How can I do this?


      Best regards,




      Holiday overview.png