Salesforce Formula to Calculate Days Between Dates

Get Days between two Dates in Salesforce Classic

I was assigned a task at work that required me to calculate the number of days between two dates in Salesforce. To fulfill this requirement, I created a formula field and used an advanced formula to display the number of days. In this Salesforce Tutorial, we will learn the formula to calculate the number of … Read more >>>

Salesforce Last Activity Date Formula Explained

Salesforce Last Activity Date Formula

A sales manager wants to know when their team last contacted each customer. They need a field that displays the most recent activity, such as a call, meeting, or email, on the account. This helps them quickly find which customers have not been contacted recently and take follow-up action. I was assigned the task of … Read more >>>

Salesforce Formula Add Year to Date

Salesforce Add Year to Date

In this Salesforce Tutorial, we will learn how to add year-to-date in Salesforce. Moreover, we will go through the steps to add the Year-to-Date Field in Salesforce. In addition, we will go through a special case based on the user’s requirements. The special case is “Salesforce Formula Add Year To Date, where the End Date should be … Read more >>>

Calculate DateTime Field Difference in Salesforce

Difference between two datetime field in Salesforce Classic Example

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 >>>

Salesforce Date Range Formula

Check if Date falls within range in Salesforce Lightning Example

While working for an organization that uses Salesforce, I was assigned a task to find all opportunities that were created in the last 30 days. So, to fulfill this requirement, I define an advanced formula that checks the date range. Using a Date Range Formula, the user can automatically check if the opportunity creation date … Read more >>>

Salesforce Due Date Formula: Calculate Due Dates with Examples

Salesforce Due Date Formula

When I was working as a Salesforce Admin in a company, they wanted to set a Payment Due Date on every Invoice record automatically. They wanted the Due Date to be 30 days after the Invoice Date. Instead of asking users to enter the due date manually each time, I created a formula field in Salesforce that calculated it … Read more >>>

How to Create a Salesforce Formula Field to Calculate Age

Calculate Age Formula Field in Salesforce Lightning Example

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 >>>

Salesforce Formula Field to Check Null Values for Dates

Check If Date Field Is Null in Salesforce Lightning

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 >>>

Salesforce Date Formula Business Days

Salesforce Date Formula Business Day

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 >>>

Agentforce in Salesforce

DOWNLOAD FREE AGENTFORCE EBOOK

Start with AgentForce in Salesforce. Create your first agent and deploy to your Salesforce Org.

Salesforce flows complete guide

FREE SALESFORCE FLOW EBOOK

Learn how to work with flows in Salesforce with 5 different real time examples.