Report to pull range value based on current day and Date Picker custom attribute value
Hello,
We are building a form that prompts a Requestor to input a service date (Anticipated Service Date), via a Date Picker custom attribute, that is sometime in the future.
We’d like to have a report on a desktop to track these that pulls in these tickets once the current date is within 7 days of the future Anticipated Service Date (ASD) date value on the form (e.g. if the ASD is 2/12/24, we’d like for it to be visible on the report beginning 2/5/24), and to remain on the report indefinitely—even beyond the ASD, if needed—until it is updated to a status different to what is being captured.
If someone happens to enter an ASD in the past, or within 7 days (0,1,2,3,4,5,6,7) relative to the current day, these tickets should automatically be visible on the report once submitted.
Is there a way to achieve this?
Answer (1)
Hello Tanner,
I would think your filter would just need to look something like this:
- ASD is less than or equal to the run date + 7 days, AND
- ASD is greater than or equal to the run date - 7 days
This would give you a range of 14 days for the tickets to appear on the report. You could further report on like the status of the ticket to make sure the ticket is not one that is already resolved.
Sincerely,
Mark Sayers
Sr Support Consultant, CS