You need to sign in to do that
Don't have an account?
Banti
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.
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.
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
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.