+ Start a Discussion
BantiBanti 

Email notification based on Businessdays

Hi,

i want to send email notification to case owner , if the case is even open in after 3 businessdays of case created date.

i am trying to create formula field for calculating businesdays (without Satday, Sunday) but getting errors.

How can i do this.?? any help

-
Thanks in Advance.
Banti.
Chandra PrakashChandra Prakash
Hi, Banti

For  calculating businesdays (without Satday, Sunday) please use below formula....

CASE(MOD( Start_Date__c - DATE(1985,6,24),7),
  0 , CASE( MOD( End_Date__c - Start_Date__c , 7),1,0,2,0,3,0,4,0,5,1,6,2,0),
  1 , CASE( MOD( End_Date__c - Start_Date__c , 7),0,0,1,0,2,0,3,0,4,0,5,2,2),
  2 , CASE( MOD( End_Date__c - Start_Date__c , 7),0,0,1,0,2,0,3,1,2),
  3 , CASE( MOD( End_Date__c - Start_Date__c , 7),0,0,1,0,2,1,2),
  4 , CASE( MOD( End_Date__c - Start_Date__c , 7),0,0,1,1,2),
  5 , CASE( MOD( End_Date__c - Start_Date__c , 7),0,1,2),
  6 , CASE( MOD( End_Date__c - Start_Date__c , 7),6,2,1),
  999)
  +
  (FLOOR(( End_Date__c - Start_Date__c )/7)*2)





Regards,
Chandra Prakash Sharma
Bisp Solutions inc.
http://bisptrainings.com


AgiAgi
Hi,
you can create a formula field, return type checkbox on cases,
which will be checked if the case is open and today-created date is greater or equal to 3 business days.

IF(
AND(
NOT(IsClosed),

(CASE(MOD(Datevalue(CreatedDate) - DATE(1985,6,24),7),
0 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
1 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
2 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
3 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
4 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
5 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
6 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
999)
+ (FLOOR((Today() - Datevalue(CreatedDate))/7)*5)
-
IF(OR(
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=0),
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=1)), 1, 0)) >= 3),

true, false)


then create a workflow rule with criteria - the above checkbox is true- and add the immediate email alert workflow action.