How to exclulde Weekends & holidays in Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2018 05:03 AM
Hello ctomasi,
I created a report where i need to pull all the tickets which are not updated since last 2 days, for which i use the condition as Active is True & Updated before Yesterday which is working fine but when it is a weekend say like today is Sunday it is pulling before yesterday means the tickets which are not updated since last Friday but not Wednesday ?
I need to set a Scheduled Report where manager should receive the tickets whcih are not updated since last 2 days please help me out how to acheive this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2018 05:25 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2018 05:54 AM
The short answer is - you're going to get this from the updated field. That's a straight date field and is checking calendar values against that field value to get a numerical difference.
My first thought is to create your own 'diff' field and maintain that yourself. Run a scheduled job daily (perhaps hourly) to find records that were not updated in the last 4 hours and increment the "day" value on that field if it has not been updated on a business day. You can then use your report to check for field values > 2 in that field. It doesn't have to go on a form to be used, but it does have to be on the table somewhere so the script (and report) can reference it.
For what it's worth, this is a bit of a customization for a single report. Make sure whomever is request this understands the development effort involved - it's not available OOB and will require updates, testing, etc. in the future. Adding cost (and time) to this requirement. Be sure they are willing to fund it and accept the ongoing risks/costs.
Perhaps someone else will jump in with a simpler solution, but I don't have one at this point.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2018 07:14 AM
My thought was to configure an SLA which reset every time the ticket was updated. With this, we could use a schedule and calculate business hours/days.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2018 07:26 AM
Adam,
Can you please help me with the screenshot we need to fix it by this week