Report to pull range value based on current day and Date Picker custom attribute value


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?

Tags report custom-attribute datepicker date-range
Asked by Tanner Grubbs on Thu 1/25/24 2:54 PM
Sign In to leave feedback or contribute an answer

Answer (1)

This answer has been marked as the accepted answer
Mark Sayers Thu 1/25/24 3:27 PM

Hello Tanner,

I would think your filter would just need to look something like this:

  1. ASD is less than or equal to the run date + 7 days, AND
  2. 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.

Mark Sayers
Sr Support Consultant, CS

1 of 1 users found this helpful.
Thanks, Mark! I'll play around with it and let you know if I have any further questions. - Tanner Grubbs Thu 1/25/24 3:36 PM