End of service calculation

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

Tia

what i have is an employee database and i want to apply the following
rules :
Employee Name
Total Package
Total Per Day
Additional days
Total Working Months
Total Working years
Type :Termination/resignation

If the employee is resigning before the completion of 1 year of
service :
He will be getting as benefits total working days -45 days of deduction
+ additional days


If the employee is being terminated before the completion of 6 month
He will get total working days+ additional days


If the employee is being terminated after the completion of 6 month
he will get 1 month salary + additional days
 
You need to try working with Datediff. Datediff works like this:
Datediff(["m", [Yourfirstfield],[yoursecondfield])
You can also add or subtract months (the "m" is for months, you can also do
"d" for days)
So Datediff("m",[firstfield],[secondfield] +7)
Experiment with that and see if you get the results you want.
 
Back
Top