T
T
I need to do a calculation when an employee is eligible for a certain
benefit. The eligibility is basically the first day of the first
calendar
quarter (4/1) or 2nd eligible (10/1) AFTER one complete year of
employment. For example, if a person's
hire date is 9/5/2003, he becomes eligible on 10/1/2004, which is one
year
(9/5/2003 to 9/5/2004), plus the first day of the next quarter, which
is
10/1/2004. If his hire date is 10/2/2004, he won't be eligible until
4/1/2006, which is one year (10/2/2004 to 10/1/2005), plus the start of
the
next quarter which is April of 2006. Does anyone have any idea how I
can
accomplish this using [HireDate] as the starting point? I hope this is
clear!
benefit. The eligibility is basically the first day of the first
calendar
quarter (4/1) or 2nd eligible (10/1) AFTER one complete year of
employment. For example, if a person's
hire date is 9/5/2003, he becomes eligible on 10/1/2004, which is one
year
(9/5/2003 to 9/5/2004), plus the first day of the next quarter, which
is
10/1/2004. If his hire date is 10/2/2004, he won't be eligible until
4/1/2006, which is one year (10/2/2004 to 10/1/2005), plus the start of
the
next quarter which is April of 2006. Does anyone have any idea how I
can
accomplish this using [HireDate] as the starting point? I hope this is
clear!