Extend filter on absence date to cover absences in last 4 years

We need to report on absence occurrences and total within the last 4 years to calculate half pay or nil pay for employees. The current query builder only allows to go back 999 days, so we cannot create a 'rolling query' for this.

Describe the Challenge

Automate (ripple) alert to manager if employee is reaching half pay/nil pay absence levels.