Quarterly accrual based on employee hire date

Summary

Quarterly accrual based on employee hire date

Content

Hi Team,

We are trying to achieve one of our client's requirement where in client wants leave accrual to be done quarterly based on employee hire date.

Ex: If any employee hired on 10-Jan-2018, his/ her accrual should run and add 50 hrs to their balance as on 09-Apr-2018 and on the 4th quarter end 150 hours must be added to employee balance. i.e.,

Employee Hire Date	Accrual period Start	Accrual Period end	Accrual Rate
10-Jan-2018	10-Jan-2018	09-Apr-2018	50
	10-Apr-2018	09-Jul-2018	50
	10-Jul-2018	09-Oct-2018	50
	10-Oct-2018	09-Jan-2018	150

 We have written fast formula which is fetching and calculating the accruals correctly, for the employee who have been hired on '01-Jan' .