How to show only table rows with date =now or =today

Question

Use case: page properties report used for 'Upcoming Events'

How to show only table rows with date >=now or >=today

I have a page properties report table and a table filter around

How to filter the table to show only rows where in column 'Date' the date is today or in the future?

Thanks for help in advance

Regards
Daniel

Katerina Kovriga {Stiltsoft} · Answer

Note that such JQL expressions as "-2d" are also available for the Date filter.

Daniel Keel · Answer

Thanks a lot

I hoped it should be easy, but so easy.
I struggled how to save the value today.

No it works fine.

Regards
Daniel

Katerina Kovriga {Stiltsoft} · Answer

Hi @Daniel Keel ,

You've already found the solution yourself: use the "today" expression.

Here is the whole table and today is 12 Feb 2021:

Here I filter dates that are >= today:

Here I filter dates that are <= today:

And here I filter only today's dates: