AnsweredAssumed Answered

Holiday Year / Entitlement / Days Left

Question asked by globe11123 on Jul 6, 2018
Latest reply on Jul 10, 2018 by globe11123

I've started to implement a holiday/absence request system. Using employee and a holiday table.

 

I'm up to the point where I've calculated how many days a person has accrued from two dates located on the employee, holiday year start and holiday year end. Currently set to 1/1/18 to 31/12/18.

 

What's confusing me now is how do these figures refresh for the next year? I'm not sure I've designed this efficently.

Also how can I show holidays left for the current year, not taking into account past years?

Would it be best showing these "statistics" on the employee record or within each holiday line?

 

Headache arghh!!

Outcomes