Eligible date

[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

 

[Douglas J. Steele]

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?

 

[T]

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