AnsweredAssumed Answered

Excluding Weekends while calculating days open in CABI Report

Question asked by ArunavaS on Nov 24, 2017
Latest reply on Nov 28, 2017 by ArunavaS

Hello All,

We have a requirement to pull a report based on the days open for Incident and Request. If days open > 3 and active=1, the ticket should appear in the report. However we also need to apply a trick to exclude saturdays and sundays from the calculation. That simply means if I run the report on Monday, it should not fetch any tickets opened on last thursday and friday as saturday and sunday came in between. Is it poosible to design a such report? Can someone help me with a sample SQL code or operation we need to perform to achieve this.

 

Thanks

ArunavaS

Outcomes