I see the answer to the earlier Question: Setting SLA Deadlines within business hours.
I applied Erick's suggestion:
Please try the ff. field and formula in the Results tab of your saved search:
- Field - Formula (Date/Time)
- Formula - CASE WHEN TO_CHAR({createddate}, 'HH24') = 8 THEN {createddate}+8/24 WHEN TO_CHAR({createddate}, 'D') = 6 THEN {createddate}+3 WHEN TO_CHAR({createddate}, 'D') = 7 THEN {createddate}+2 ELSE {createddate} + 1 END
- Custom Label - SLA Deadline
but the SLA Deadline doe not seem correct.
Example:
Case was created over the weekend and Monday business hours begin at 8 am. This formula indicates the case SLA is 6 hours after the start of business on Monday instead of 8.
This formula looks like it is just adjusting the "days" to move through the weekend but does not account for the business hours in a day.
In my scenario, Our SLA is first contact within 24 hours. I need to create a saved search as the basis for an alert to the Support Manager when a case SLA is within 4 hours so that the Support Manager can ensure the SLA is met. The SLA should not include weekends or non-business hours. Our Business Hours are 8am -5pm local time Monday through Friday.
I suspect I will need to create a couple custom CRM fields to calculate each case SLA
- CRM field to calculate the SLA where Store Value is NOT checked.
- CRM field to read the Field 1 and Store Value IS checked so I can use it in reporting.
I can determine if a case was created during Business Hours by using:
Formula (Text) case when to_char({createddate},'D') in ('2','3','4','5','6') and (to_char({createddate},'hh24:mi') between '07:00' and '17:00') then 'Yes' else 'No' end
I need to properly calculate the SLA based on work days and business hours.
I have added this scenario to the SuiteIdea 450157 asking for a Work Calendar for use in Support Management but need a temporary work around.
Any suggestions?