prashanth
Member-
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
Salesforce Future Trends: 5 Major Trends to Watch Out For (2022 - 2023)
Salesforce trends for the year 2022-2023! Has it created too much buzz around? Well, possibly yes! Coz it is worth it… For more than two…
Setting Up Subscription Products and Making Configuration Decisions in Salesforce CPQ
We are back again with our Managing Your Subscription Products with Salesforce CPQ series. In our previous blog, we introduced different subscription models on a…
Using Batch Apex in Salesforce | The How-to Guide
Batch Apex Batch Apex is used to run Large Jobs that would exceed processing limits. By using Batch apex, We can process thousands of records…
Popular Salesforce Videos
Salesforce Macros - All You Need To Know!
Macros in Salesforce allows you to perform repetitive actions in Service Cloud for the records of Account, Contact, Case, and Lead (Supported for Feed based…
What is Salesforce CRM?
What is Salesforce CRM? Join this useful group for Salesforce job & career info and learn all about Salesforce CRM.
Customizing and Replacing Sample Salesforce Data
Leverage our sample use case for Salesforce to learn how HyperIntelligence works—and rapidly get your own cards up and running! In this video, we’ll demonstrate…
Popular Salesforce Infographics
Salesforce : Anatomy of a Productive Sales Rep
We are a nation obsessed with productivity. We look for ways to "hack" our way through life, squeezing the most out of every minute we…
7 Key Factors to Keep in Mind When Selecting Salesforce CPQ Software
Today, sales teams are increasingly overwhelmed with complex product offerings and customers’ expectations to deliver quick and personalized experiences. That’s why, sales professionals are inclining…
Why Salesforce End-user Training Matters for Smooth Implementation
This infographic 'Why Salesforce end-user training matters for smooth implementation' appeared first on Cynoteck. The progress of any CRM implementation depends on its general adoption…
