Vacation Calculation

J

Julie

I am working on a vacation database and I need to calculate their vacation
based on their anniversary. So, if they were hired on 12/1/93, they will be
able to have 160 hrs available to use. Each person would be different based
upon their anniversary date.
 
J

Jeff L

If you are trying to find out how many years a person has worked try
this:
DateDiff("yyyy",HireDate, Date())

You could then use that to determine how much vacation the person
should receive. Since I don't know your criteria for determining your
vacation, I don't know how to assist you further.
 
J

Julie

It is a vacation database so that if an employee comes in and asks what his
balance is on their vacation, I can just produce a report that shows his
vacation awarded and less any days they have taken. Also, how would I write a
formula to take only the month and day for the current year from their
anniversary date.
 
Top