Skip to main content

Within the Horizon rules, when filtering we often calculate period calculations based off of a date. For example, if we wanted to see total transaction amounts within the past 2 year periods (today - 12 months VS. 12 months - 24 months) we often use the Last/Next N Days filter.

 

However, Horizon limits the number of days for both next and last to 365 days, so doing the calculation above is not possible. Additionally, we would not want to use the last N months/years as days is a lot more precise.

 

Would it be possible to expand the N Days criteria to greater than 365 days?

No StatusIN DEVELOPMENT

May I request the limit be higher than 1000? I have a (now closed) ticket (#180769) about some rather awkward behavior with day limits in filters I’d like to not see ever again :)


Can we also bring back the ability to filter dates by Equals and not require Greater/Lesser than or Equal to? The added overhead of additional filters stacks up.