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 ( after insert , after update , after delete , after undelete ) {     Set < Id > accountIds = new Set < Id >();     // Insert, Update (new AccountId), Undelete     if ( Trigger . isInsert || Trigger . isUpdate || Trigger . isUndelete ) {         for ( Contact con : Trigger . new ) {             if ( con . AccountId != null ) {                 accountIds . add ( con . AccountId );             }         }     }     // Delete, Update (old AccountId)     if ( Trigger . isDelete || Trigger . isUpdate ) {         for ( Contact con : Trigger . old ) {             if ( con . AccountId != null ) { ...