As a Salesforce consultant, while working in Salesforce you will use various formulas for different operations like Date related formulas, etc. We have explained how to use Salesforce formulas in both Salesforce Lightning and Salesforce Classic. Do let us know if you have any problems using these formulas.
The MID() function in Salesforce returns a set number of characters from the middle of a text value, starting at a position you choose: MID(“Salesforce”, 6, 5) returns “force”. Combined with FIND(), it extracts text between two markers, such as the domain of an email address or the code after a “#”. Most MID tutorials … Read more >>>
I got a task at work that required me to calculate the difference between the date and time fields using Salesforce. To fulfill this requirement, I define an advanced formula. In this Salesforce Tutorial, we will learn how to calculate DateTime field difference in Salesforce. Additionally, we will review how to use Salesforce Lightning to … Read more >>>
A company wants to know the exact age of its customers based on the Date of Birth stored in Salesforce. Instead of calculating it manually every time, they want a formula field that will automatically show the customer’s age in years on the record. In this article, we will learn how to use the Salesforce formula … Read more >>>
While working for an organization that uses Salesforce, I was assigned the task of assigning the next available date to a client. To fulfill this requirement, I define an advanced formula that checks for null values in dates. In this Salesforce tutorial, I will demonstrate how to check for null values in dates within Salesforce. … Read more >>>
A company needs to calculate the delivery date of an order. The standard delivery time is 5 business days (excluding weekends). If an order is placed on Wednesday, Salesforce should automatically calculate and show the delivery date as the following Wednesday (skipping Saturday and Sunday). In this article, we learn about how to calculate business … Read more >>>
A support lead asks for a list of opportunities with no activity for more than 30 days. The answer is a date formula in Salesforce that compares the Last Activity Date with TODAY(). Salesforce date formula functions are the built-in functions (TODAY, NOW, DATE, DATEVALUE, ADDMONTHS, WEEKDAY and others) that create, convert, compare and calculate … Read more >>>