Salesforce formula get difference between two dates

Note:

I have used this formula to get the renewal opp duration which I have created in my previous post.


Assignment (don't mind the variable name)


{!SObjectV_OLI.Service_End_Date__c} +({!SObjectV_OLI.Service_End_Date__c} - {!SObjectV_OLI.Service_Start_Date__c})



{!SObjectV_OLI.Service_Start_Date__c} + 1 + ({!SObjectV_OLI.Service_End_Date__c} - {!SObjectV_OLI.Service_Start_Date__c})

Comments

Post a Comment

Popular posts from this blog

How to fix SoapUI freeze in Mac OS

Follow these steps carefully, which will fix SoapUI freeze in Mac OS. [Note: Tested in my OS X 10.11.6] Start ‘Activity Monitor’ and Force Kill your dead soapUI process. [Or use Command-Option-Escape to force quit it.] In Finder, /Applications/SmartBear/soapUI-5.0.0.app > Show Package Contents. Edit /Applications/SmartBear/soapUI-5.0.0.app/Contents/ java/app/bin/soapui.sh. Uncomment this line# JAVA_OPTS="$JAVA_OPTS -Dsoapui.browser.disabled=true". [In other words, remove the "#" to stop it being a comment.] Edit /Applications/SmartBear/soapUI-5.0.0.app/Contents/ vmoptions.txt. Add -Dsoapui.browser.disabled=true. Start soapUI. [In those paths, change  soapUI-5.0.0  to match your version. For me it is  soapUI-5.1.3 .] Referenced from:  https://community.smartbear.com/t5/SoapUI-NG/SoapUI-Pro-5-1-2-hangs-on-Mac-OS-X-10-8-5/td-p/95626
Read more

[WSO2 Open Source Enterprise Solutions] Integration: People-HR

Image
Products: WSO2 ESB, WSO2 DAS, WSO2 Developer Studio and WSO2 IOT Server. Introduction Intention of this article to demonstrate one of the real world usage of wso2 products. According to the provided architecture [Figure 1.0.0], this article will cover-up some usage of WSO2 developer studio, WSO2 Enterprise Service Bus (ESB) and WSO2 Data Analytics Server (DAS). Nowadays most of the organizations are using external systems to manage their process, management task and activities, such as Salesforce for sales, Pardot for marketing, People-HR for managing human resource...etc. This article explain, how to connect external system using WSO2 ESB connectors by providing a sample configurations using people-HR connector. WSO2 ESB Connectors facilitates you to connect with external systems and manipulate those data. Connectors are connected with the WSO2 Enterprise Service Bus (WSO2 ESB), which is a lightweight, high performance, comprehensive ESB. 100% open source, WSO2 ...
Read more

Salesforce Auto generate renewal Opportunity with Line Items (i.e. Opportunity Products)

Image
First,  let's take a look at the business scenario of this.  Each Account(customer) have a set of opportunities and its Line Items which also know as Products of that Opportunity. Once the salesperson enters those opportunity and product details in the Salesforce, those are likely to be renewed (quarterly, yearly...etc) by the customer if they are planning to go ahead with the same vendor in the next year as well. Therefore, we need to again enter the same data into Salesforce which is almost similar to the previous details which are a time-consuming tedious task.    Our objective is to automate this renewal scenario. What are the available options Writing a class which is invoked by a Visualforce page to create the new opportunity and line items (by acquiring data through SOQL in the Apex class). Writing a trigger to fire on the opportunity once the particular conditions are met. Configuring a process builder follows by a flow t...
Read more