How to filter a database view by todays date

Justin Balcombe_0owhks

I've created a simple table with dates and the names of on call people.

I can see how to filter by a specific date, but there doesn't seem to be an option to filter dynamically. For instance when I look at the data I would like to only see people on call for today's date or later, and ignore historical data.

Is there any way to tell Confluence to use the current date each time the filter is opened?

 

Stiltsoft support

Hi @Justin Balcombe ,

If we are talking about simple manually created Confluence tables, please define what app you are using for filtration, it is not possible in Confluence out-of-the-box.

We develop the Table Filter, Charts & Spreadsheets for Confluence app and its Table Filter macro understands the "today" function.

To filter by the today's date, you can use the "today" function in the date range filter. This function returns the current date as a date value. By setting the dynamic values in the date range filter's input, the filtered results will automatically update according to today's date.