Add more dynamic filter expressions relative to Current date

Problem/Motivation

Hi,

most of the date filters have limited or very static functionality.

It would be great to have filter functions in that collection that automatically derive some current filter values from the current date:

Current Year
Current Month
Current Quarter

And also a possibility to add a filter expression that allows for calculating from the current date. e.g.

Current Year -1 is last year
Current Year -2 the year before last year

Current Month -1 ... same as years

Current Quarter -1 ... same as years

So one could get data by month of previous year (e.g. to make a relative comparison):
Current Month -12
or the year before
Current Month -24

and so on.
All these make it possible to create a view once and not with hard coded date expressions...

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes