Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to run report of tasks that were closed after a specific variable date?

Brent Cox
Giga Guru

We have an offboarding request that has a specific variable to document the "termination date" of the account. Is there any way I can run a report on the tickets that are closed after this date? I tried doing a "closed 1 day after" but it doesn't seem like I can pull a variable from here. Is there a better way? 

1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

Hi Brent,

Did you try the reverse in the filter - variable... is more than #hours/days before Closed?

BradBowman_0-1729249039085.png

 

View solution in original post

3 REPLIES 3

Brad Bowman
Kilo Patron
Kilo Patron

Hi Brent,

Did you try the reverse in the filter - variable... is more than #hours/days before Closed?

BradBowman_0-1729249039085.png

 

Perfect this worked! Interesting, I normally use the classic view, and from there, I couldn't pull the same information from the report. Where you have "closed" selected at the end of this condition, this wouldn't appear at all in the other view. 

Ha!  I recently switched to the 'new UI' for reports and found I couldn't do something I could in the classic view.  I guess when one doesn't work, try the other!