SivaAPSFDC

  1.LWC Short Keys VS Code Extension for  #Salesforce 2. pmd

  However it’ll not exclude the HOLIDAYS, Because each org has its own holidays based on region /country. Hence salesforce don’t have knowledge about list of holidays. CASE(MOD( StartDate__c – DATE(1985,6,24),7),    0 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),    1 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),    2 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),    3 , CASE( MOD( EndDate__c – StartDate__c ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),    4 , CASE( MOD( EndDate__c – StartDate__c ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),    5 , CASE( MOD( EndDate__c – StartDate__c ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),    6 , CASE( MOD( EndDate__c – StartDate__c ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),    999)    +    (FLOOR(( EndDate__c – StartDate__c )/7)*5)  Steps to create: Create a formula fi...

 Contact Trigger : ================================================ trigger ContactTrigger on Contact (before insert, after insert, before update, after update, before delete, after undelete, after delete) {       Set<Id> accIds = new Set<Id>();// set to store parent account ids of contacts    map<string,Account> accconmap1=new map<string,Account>();    map<string,string> accconmap=new map<string,string>();    map<string,string> accconmap2=new map<string,string>(); if(trigger.isAfter && (trigger.isInsert || trigger.isUndelete)) { if(!trigger.new.isEmpty()){             Integer i=0; for(Contact con : trigger.new) {                  accIds.add(con.AccountId);                  accconmap.put(con.id,con.AccountId); } } } if(trigger.isAft...