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,

       

      Marco

       

      Holiday overview.png