samuel john
Individual-
samuel john started the discussion Hours between two date time formula showing negative values in Salesforce in the forum 8 years ago
Hours between two date time formula showing negative values in Salesforce
I have written a formula to calculate the difference between two Date/Time fields,
Please find the formula`ROUND(24*(
(5*FLOOR((DATEVALUE(First_Response__c)-DATE(1996,01,01))/7) +
MIN(5,
MOD(DATEVALUE(First_Response__c)-DATE(1996,01,01), 7) +
MIN(1, 24/24*(MOD(First_Response__c-DATETIMEVALUE('1996-01-01… Read more
Popular Salesforce Blogs
Save hours off your workweek with Celigo's Excel SmartClient for Salesforce
Celigo's Excel SmartClient is a powerful tool that can be used to retrieve data from Salesforce into Excel. Once in Excel the data can be modified…
Introduction of Visualforce in Salesforce
About Visualforce locally on the Lightning stage. The Visualforce structure incorporates a tag-based markup language, like HTML, and a lot of server-side "standard controllers" that…
Validation Rules in Salesforce - Get Started
What Are Validation Rules and How Do They Work? Validation rules are frequently used to ensure the integrity of data or records. Validation rules are…
Popular Salesforce Videos
UiPath automation for Salesforce | REST API commands | OAuth2 | Download files | Without activity
How to send a raw REST API command from UiPath to Salesforce without using custom activities. 0:00 Intro 1:35 OAuth2 4:10 Download files from a case, opportunity, account,…
How To Filter Salesforce Reports via URL Parameters - Learn Salesforce Series By Algoworks
How To Filter Salesforce Reports via URL Parameters In this video, the following points will be covered - 1. Introduction Get a brief introduction to…
10 Example Future Method with Test Class | Asynchronous Apex | Salesforce Development Training Video
Salesforce uses a queue-based framework to handle asynchronous processes from such sources as future methods and batch Apex. This queue is used to balance request workload across…
Popular Salesforce Infographics
Customer Service: The Forgotten Marketing Channel
The key to good customer service is building good relationships with your customers. Thanking the customer and promoting a positive, helpful and friendly environment will…
How to Become a Salesforce Consultant?
Begin your Salesforce Consultant journey with Trailhead to learn about the modules offered by Salesforce to its users - admin, business users and developers to…
Why Integrate Your Pardot Account with Salesforce?
Salesforce Sales Cloud is primarily a sales tool while Pardot is a marketing automation platform. Both are designed to increase sales and maximize efficiency for…
