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.

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 ).

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 .

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

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/

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

If you can help me how to do the history table please

I am still waiting for the answer

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