Dynamic "Today" filtering

[dsert1]

Feature request

Is your feature request related to a problem?

Yes

Please describe. I need to be able to report on a specific event only when the "appointmentDate" property is before today. The problem is that right now, I don't have a way for that to be dynamic. I can only set it to today's date, which is out-of-date by the time it's tomorrow.

Describe the solution you'd like

I need a "Today" button that will automatically fill in HogQL today() rather than a date as a literal.

Describe alternatives you've considered

I tried creating an Action like so, but I found it to be very clunky and unintuitive. Most people wouldn't be able to figure this out and it took more time from my day than I would have liked.