End of service calculation

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
 
G

golfinray

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top