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

# Calculation retirement date

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.

Grz. Michiel

• ###### 1. Re: Calculation retirement date

I'm not sure I'm spotting the pattern correctly in your example.

In the section marked by "..." the retirement age increases by one month every 11 months?

A case function can calculate this in pretty straight forward fashion.

• ###### 2. Re: Calculation retirement date

No, that's not the case.

The whole list (in Dutch, but you will understand)

Before 1-1-1948: 65 year

 1-1-1948 en 30-11-1948 2013 65 + 1 maand 1-12-1948 en 31-10-1949 2014 65 + 2 maanden 1-11-1949 en 30-9-1950 2015 65 + 3 maanden 1-10-1950 en 30-6-1951 2016 65 + 6 maanden 1-7-1951 en 31-3-1952 2017 65 + 9 maanden 1-4-1952 en 31-12-1952 2018 66 1-1-1953 en 31-8-1953 2019 66 + 4 maanden 1-9-1953 en 30-4-1954 2020 66 + 8 maanden 1-5-1954 en 31-12-1954 2021 67

After: 31-12-1954: 67

• ###### 3. Re: Calculation retirement date

Hi Michiel,

I cobbled together a start of an calculation in an example file. I to, did not have the complete pattern but I think you might be able to put it together anyway.

With best regards Magnus Fransson.

1 of 1 people found this helpful
• ###### 4. Re: Calculation retirement date

Dear Magnus,