I have an "employee" object that has staff information including leave balance which is a formula that has an accrual rate and subtracts from a child object "leave requests" roll-up sum.
The use case is that every year, on Jan 1, if an employee has accrued more than 10 days then in the new year the leave balance has to refresh to ten days. E.g. if I have 14 days in December 31, then on January 1, this needs to automatically deduct to 10 days.
How can a formula field be updated on a specific date, continuously? NO CODE preferable, but if you have an Apex solution, please consider that I am a novice in your explanation.