IBM Targetprocess

 View Only

 Current Date filter in Report

Eric Katzman's profile image
Eric Katzman posted Fri June 06, 2025 10:08 AM

Does anyone know of a way to add a current date filter to a report?  I am looking for something like Current Date + Next 90 days.

Alex Allan's profile image
Alex Allan posted Thu June 19, 2025 01:47 PM

Hi Eric, If I understand your ask correctly, the solution you're looking for will be as follows...

1)  Select the "Planned End Date" within the slicer visible in your screen shot

2)  Check the "Planned End Date" tick box that will appear

3)  Select the date range, From and To

Hope this helps.  If not, please reach back out and I'll see about arranging a call with one of our SME's.

Thanks Eric.

Alex.

Eric Katzman's profile image
Eric Katzman posted Fri June 20, 2025 10:14 AM

@Alex Allan
Thank you for replying, but I am looking for like an excel formula. 

=TODAY() + 90 days
Using today date to see a view that always shows 1 month in the past and 3 months in the future.  Like a roadmap view that shows items due in the short term. But more importantly the report filter always stays up to date and only sees 3 months future. 

If I used your answer below step 3 would look like this

1)  Select the "Planned End Date" within the slicer visible in your screen shot

2)  Check the "Planned End Date" tick box that will appear

3)  Select the how many days in the future and/or past from today you looking to see



Alex Allan's profile image
Alex Allan posted Fri June 20, 2025 10:42 AM

Hi @Eric Katzman, makes sense.  Let me see what I can find out for you.  I'll revert with a view on whether or not this is currently possible.  If not, we may need to consider submitting an ideation.

Related Content