Retirement

Summary

Eligible to Retire

Content

To be eligible for the pension plan an employee has be to be aged 65 or meet the “magic 80” rule which is the employees’ start date + age = 80.

I wrote a report to determine who would be eligible in less than one year, 1-less than 3 years, 3-less than 5 years and 5+. I calculated it on SQL_TSI_month but it rounded up so I want to calculate using SQL_TSI_day but I am having trouble making a formula work.

My formula for 1 Year to Less than 3 Years using months was:

case when   ((960 -(TimestampDiff(SQL_TSI_month,"Worker"."Employee Date Of Birth",CURRENT_DATE)+TimestampDiff(SQL_TSI_month,"Worker"."Person Start Date",CURRENT_DATE))) /2) <12 or  (780-(TimestampDiff(SQL_TSI_month,"Worker"."Employee Date Of Birth",CURRENT_DATE)))<12  then null