Good Afternoon everyone-
I am a Human Resources Assistant creating a database for my director to keep
track of all Full Time Year Round employees.
I am having trouble doing date calculations. An employee needs to be active
for 90 days from the date they started Full Time Year Round (FTYR) and then
wait to the beginning of the next month in order to join the health program.
As an example, if an employee has a hire date of 01/15/06 their 90 days would
be 04/15/06. But they would have to wait until May 1 to join the health
insurance program. The formula I used in my form to figure 90 days looks
like this:
=DateAdd("d",90,Forms![Entry Edit Frm]!FTYRDate)
Does anyone know if I can add something to the formula to make it calculate
the 90 days plus going to the first of the next month? I also need to come
up with a similar formula for pension, which would be 1 year of service and
then either one of two open enrollment dates; May 1 or Nov 1 whichever is
closer.
Thank you in advance for your time and any help you can provide.
-A
|
Similar Threads
