Report - Dynamic report that looks at Changes between 2 set days and times

Josh80 · ‎06-09-2017

Hello All

I know this is nothing new, but I cannot find anything related to this on the Community.

Using the Condition filter on a list report, I need to have a report that shows all changes between Monday at 17:00 through Thursday at 16:00...but I don't see a way to do that

without some magic scripting. Am I correct and if so can anyone provide some assistance? I did see one Community question where a script include was mentioned.

Thank you in advance!

Patrick Schult2 · ‎06-09-2017

Try this. If you want to add more filters, you basically just need to add them to all 3 sections. For example, if you wanted this to only show closed changes, you would add an "Active = false" filter to all 3 sections.

View solution in original post

Patrick Schult2 · ‎06-09-2017

What's it doing? Just no records returned or what? Provide a screenshot of the full report if you can.

If your conditions are correct and you are getting no records, you might manually verify there is a change that should be in the report. It seems to work correctly for me.

Josh80 · ‎06-09-2017

It's pulling other dates in also.

On Jun 9, 2017 5:45 PM, "patrickschulte" <community-no-reply@servicenow.com>

Patrick Schult2 · ‎06-09-2017

I'm not really sure what the problem is - attach a screenshot of your report showing a record you aren't expecting. I double checked and my report is showing CRs with a planned start date this week between Monday 5pm and Thursday 4pm so it looks like it does exactly what you are describing.

Josh80 · ‎06-09-2017

I will double check and let you know

On Jun 9, 2017 23:58, "patrickschulte" <community-no-reply@servicenow.com>

Josh80 · ‎06-13-2017

Hey Patrick...I was missing a line in the condition and this works great.
Next challenge is how to do a report that spans not just 'this week' but Monday of 'next week'.

I think I know how to do it based on the help you've given me. Thanks again!