Gourav Deep Das
Member-
Parmanand Shete replied to the discussion How to calculate days between two DateTime values excluding weekends? in the forum Salesforce® Discussions 5 years ago
Reply to How to calculate days between two DateTime values excluding weekends?
(5 * FLOOR( ( DATEVALUE(End_Date__c) - DATE( 1900, 1, 8) ) / 7 ) + MIN( 5, MOD( DATEVALUE(End_Date__c) - DATE( 1900, 1, 8), 7 ) ) ) - (5 * FLOOR( ( DATEVALUE(Start_Date__c) - DATE( 1900, 1, 8) ) / 7 ) + MIN( 5, MOD( DATEVALUE(Start_Date__c) - DATE( 1900, 1, 8), 7 ) ) )
Here Start_Date__c is earlier date and End_Date__c is new one which is… Read more
-
Parmanand Shete became a registered member 5 years ago
Popular Salesforce Blogs
Access sObject's (Salesforce Object Type) Fields and Its Record | Apex Developer Guide
There are multiple cases where you need to show sObjects records and its field in Lightning. For example: Consider a use case scenario where you…
What is Batch Apex in Salesforce? | All You Need to Know
Batch Apex allows developers to process large amounts of data in a batch, without hitting governor limits, which are limits on resources like CPU time,…
Quickbooks and Salesforce Integration: Rest API
In today’s business landscape, seamless integration between different software systems is essential for maximizing productivity and efficiency. When it comes to managing financial data and…
Popular Salesforce Infographics
How Salesforce is Beneficial For Your Business
There is a saying frequently heard many times which is “ Customer is a King”. So, a business needs to do everything to satisfy the…
Salesforce CPQ, AI for Smart Selling
Sales teams embracing AI are seeing an expansion in leads and arrangements of over half, cost decreases of 40%–60%, and call time decreases of 60%–70%,…
Salesforce Implementation Service
Revolutionize your business with the power of Salesforce Implementation Services! Unleash unparalleled efficiency, seamless collaboration, and unparalleled growth. Our latest infographic breaks down the key…
