Eligible date

  • Thread starter Thread starter T
  • Start date Start date
T

T

Hi All
I have a form which the user types in the gross pay. In order for the
vesting to calculate the employee has to meet certain eligibility
dates.
Hired 4/1/2006 Elig 4/1/2007
Hired 4/2/2006 Elig 10/1/2007
Hired 10/2/2006 Elig 4/1/2008

I have a table with the 4/1/2006 as Beg FY Date and
10/1/2006 as Effective Date
Of course each FY has a differend year.

I also have an employee table that has the Hire Date.

On the main form is a Check Date which the user inputs.

I just can't seem to get my head around this. I've tried
datediff(d,HireDate,CheckDate)>365 then
do the calculation.
Help please?

Thanks
 
It's not clear to me what you're trying to do.

What is Check Date supposed to be? What is its relationship to beg FY Date
and Effective Date?
 
Sorry it took so long. One of many projects.
The check date is when the employee received the check from ADP. I
thought I could use it to calculate the number of days between it and
beg FY Date. Or the user can insert an effective date and I check to
see if it's greater than the check date.
There are only two eligible dates:
4/1/ and 10/1

The FY date runs 4/1/current year to 3/31/following year
4/1/2006 to 3/31/2007.
If the employee started between 1/1/2006 and 4/1/2006, they are
eligible 4/1/2007.
If the employee started between 4/1/2006 and 10/1/2006, they are
eligible 10/1/2007.
If the employee started after 10/1/2006 they are eligible 4/1/2008.

I think I'm going about it the wrong way. If you have any suggestions,
I would so appreciate it.

Thanks
 
Back
Top