Can we create dynamic database view according to date?

[Tami Dubi]

Hi, all;
I have a Support team use case that will benefit your collective thinking and perhaps trigger a feature request.
In our support landing page (space overview page), we created an ongoing section for issues that the support members should know when going on shifts. 

Currently, the Ongoing section is done by page property and page property report macros and managed manually. This means we have start date and end date columns, which the support manager views and removes manually once the end date has passed by archiving the pages. We have several ongoing tables for different usages in support, so the maintenance is hard. 
I was considering replacing the above with a database, and I wanted to use the advantage of the date field so that the database will include all of the ongoing (past and present), but the view to the support team will include only the ongoing that are in the date range that was defined in the table.

Challenges in implementing the solution in the database:

1. As I checked, the date column doesn't have a date range option
2. The viewing date filters are included before and after, but once set, they are static.
I wish to have a filter that will show me only the relevant rows for a variable of "today," whose values change daily. 
I would appreciate your thoughts and suggestions regarding this matter. 
Thanks,
Tami

[Kristian Klima]

Hi @Tami Dubi 

I'm using the last updated column and just arrange entries by date to see the latest, typically, I'm scouting for stuff update since the last release (two weeks ago).

Not ideal :) 

But there are also apps that might help, Panorama by Kolekti (Adaptavist) or Pages Manager for Confluence by Ricksoft.

[Tami Dubi]

Thanks, Kristian,
We are trying to avoid using additional add-ons and to make the database useful. I believe that developing the date field to actually work as a date ( not just visually but functionally) will improve the database solution.
Best,

Tami

[Kristian Klima]

@Tami Dubi 

I think Pages Manager is free ;) 

[Robert Hean]

@Tami Dubi  - Love the idea for the feature!

While not a solve, I would be curious if you've explored automations - sounds like the "...removes manually once the end date has passed..." could be a candidate?

Another possible solve could be to use Jira tickets? e.g. have a filter that only shows open issues that don't have an end date, then trigger an automation to archive the related page?

[Tami Dubi]

HI @Kristian Klima ,

Yes, it is free, and we have it, but I don't think it's useful for our use case. The ongoing is a section of a landing page where the Support Rep can view all their daily issues organized for their work. The page manager assists in managing pages, but I am looking for both ease of management and embedded viewing for users. 
Best,

Tami