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

[Daniel Keel]

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}]

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:

[Daniel Keel]

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}]

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