Date/DateTime filter with "In the past" and "In the future"

,

It’s sometimes useful to filter by date/datetime fields relative to the current date.

I’d be great to add 2 options to date/datetime filter - “is in the past” and “is in the future”.

This would be useful and improve developer experience, there are many situations where you just need to filter records by the current date, for example, filter expired offers or coupons from the results. Having to pass the current date time manually in every query is not optimal.