4 Replies Latest reply on Sep 25, 2016 1:00 PM by Michiel

    Calculation retirement date

    Michiel

      Hi Guys,

       

      At first: Excuse me for my English, it's not my native language.

      I have some difficulties regarding to the calculation of the retirement date. In the Netherlands the retirement date is depending on the day of birth:

      (dates in Dutch format: day:month:year)

       

      Before 1-1-1948: 65 year

      Between 1-1-1948 and 30-11-1948: 65 year+1 month

      Between 1-12-1948 and 31-10-1949: 65 year+2 monhs

      ....

      After 31-12-1954: 67 year

       

      In my solutions I have the fields "DayOfBirth" and "Retirementdate". I'm searching for the calculation of the "Retirementdate" field.

      For example, if the day of birth is 20 may 1960 (20-05-1960), the calculated date of retirement must be 20-05-2027.

       

      Thank you all in advance for your comments.

       

      Grz. Michiel