Our client case is:
Say today (April 10th), the report should have courses(data) listed that are expired within next 60 days.
On May 10th, they’d want auto report to send with courses that would expire within 60 days after May 10th.
Same for subsequent months.
My guess is I need to filter the data by: “N days from now” but I’m struggling with filtering the data that way.
I tried the steps here:
When I do step 2, no other dialog box pops up and doesn’t seem to be doing anything! How do I even get to step 3, or is step 3 even needed? I’m trying to filter on a column with expiration dates and I only want to see courses that expire within 60 days!