silentdragonfly
New Member
- Joined
- Dec 19, 2014
- Messages
- 28
Our employees are offered a retirement benefit based on the following criteria:
1. must be full time
2. must attain 15 years of consecutive service
3. must achieve one of the following:
a. if age is between 55 and 61 and combination of age and years of service is greater than or equal to 85
b. if age is between 62 and 64 and combination of age and years of service is greater than or equal to 82
c. if age is over 65 and have at least 15 years of consecutive years of service
I have a database of Name, Date of Hire, DOB. I've figured out how to calculate who is eligible but am getting stuck with projecting when they would qualify in the future. Here are 2 examples. The first EE calculates appropriately but since the 2nd doesn't qualify until sometime in the future, it should add one year to the EE's age and one year to the EE's years of service until they reach the requirements in #3 above. This is the part I am stuck on.
Can anyone help?
[TABLE="width: 223"]
<colgroup><col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;"> <tbody>[TR]
[TD="width: 44, bgcolor: transparent"]Name[/TD]
[TD="class: xl67, width: 75, bgcolor: transparent"] DOH[/TD]
[TD="class: xl67, width: 68, bgcolor: transparent"] DOB[/TD]
[TD="width: 111, bgcolor: transparent"]When qualified?[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]EE1[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9/24/1986 [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8/10/1960 [/TD]
[TD="bgcolor: transparent"]Qualified 2017[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]EE2[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]12/26/1989[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1/1/1965[/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
1. must be full time
2. must attain 15 years of consecutive service
3. must achieve one of the following:
a. if age is between 55 and 61 and combination of age and years of service is greater than or equal to 85
b. if age is between 62 and 64 and combination of age and years of service is greater than or equal to 82
c. if age is over 65 and have at least 15 years of consecutive years of service
I have a database of Name, Date of Hire, DOB. I've figured out how to calculate who is eligible but am getting stuck with projecting when they would qualify in the future. Here are 2 examples. The first EE calculates appropriately but since the 2nd doesn't qualify until sometime in the future, it should add one year to the EE's age and one year to the EE's years of service until they reach the requirements in #3 above. This is the part I am stuck on.
Can anyone help?
[TABLE="width: 223"]
<colgroup><col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;"> <tbody>[TR]
[TD="width: 44, bgcolor: transparent"]Name[/TD]
[TD="class: xl67, width: 75, bgcolor: transparent"] DOH[/TD]
[TD="class: xl67, width: 68, bgcolor: transparent"] DOB[/TD]
[TD="width: 111, bgcolor: transparent"]When qualified?[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]EE1[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9/24/1986 [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8/10/1960 [/TD]
[TD="bgcolor: transparent"]Qualified 2017[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]EE2[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]12/26/1989[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1/1/1965[/TD]
[TD="bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]