Jump to content
Nippon Maru

Calculation of Annual Leave Entitlement

Recommended Posts

Hello Guys.

I want to create a Calculation that will do the following

Each worker is entitled to 45 days holiday per year The standard annual leave entitlement for a full-time member of staff is 45 days including public holidays and customary days.

I would just like to be able to put his start date in a filed and then automatically generate how many days holiday he would be entitled and how many days remaining and the end date

I want to keep a history table for each worker when he took his leave and how many days he have.

Like this

1- Emp_Id emp_name , start_date , end_date , total_days, rem_dates

Hope this is enough info.

Thanks in advance.

Share this post


Link to post
Share on other sites

The vacations history table needs only these fields:

• EmpID

• StartDate

• EndDate

• cTotalDays (calculation)

The calculation of remaining days should be done in the Employees table. Calculate how many years the employee has been employed, multiply by 45 and subtract Sum ( Vacations::cTotalDays ).

Share this post


Link to post
Share on other sites

Thank you very much for taking the time to reply to me. I really appreciate it

Can you please write The formula how to do the Annual leave calculation

and the The vacations history table .

Share this post


Link to post
Share on other sites

Is there a maximum number of days that they can have on the books before they lose them?

Share this post


Link to post
Share on other sites

There is not much else I could add. You already know how to calculate the number of years from here:

http://fmforums.com/forum/showpost.php?post/333464/

Share this post


Link to post
Share on other sites

Nope , theres NO maximum number of days that they can have on the books before they lose them?

Share this post


Link to post
Share on other sites

10 years later? If you haven't figured it out in 10 years then maybe time to hire someone?  lol  😂

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.