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

Salesforce Formula: Check if Date Greater Than Specific Date

Salesforce Classic Formula date greater than specific date

I was given a task while employed by an organization to determine whether a date exceeds a certain date. It enables us to streamline workflows and processes depending on particular dates, as well as better manage and organize our data in Salesforce. In this article, we will learn how to check if a date is greater … Read more >>>

Date Formula Functions in Salesforce

Date Formula Functions in Salesforce

While working as a Salesforce Administrator, you may need to assist the sales team in tracking inactive opportunities. For example, if an opportunity has no activity for more than 30 days, you can create a formula that compares the Last Activity Date with the TODAY() function. This will flag opportunities that need follow-up. In this … Read more >>>

Salesforce Checkbox Formula Field: Use Cases & Examples

How to Create Salesforce Checkbox Formula Field

While working as a Salesforce Admin, we sometimes need to quickly identify records that meet specific conditions without creating any automation, such as a Flow or Process Builder. For example, the sales team wants to know if an opportunity’s Close Date is before TODAY() and the Stage is not “Closed Won” or “Closed Lost“. Instead of asking users to … Read more >>>

Salesforce Picklist Default Value Formula

Salesforce Classic Default Picklist Value Formula Example

In my Salesforce organization, I was setting up a new custom object to track service requests. Each request record required a status field with values such as New, In Progress, and Closed. Since every request should always start in the New stage, I didn’t want users to manually select the picklist value “New” each time they created … Read more >>>

How to Convert DateTime to Date in Salesforce Formula

Convert DateTime to Date in Salesforce Formula

In Salesforce, DateTime fields always include both the date and the time, for example: 28-Aug-2025 3:45 PM. However, in many business scenarios, users only need the date. For example, we want formulas that require comparison with TODAY(), such as checking if a follow-up DateTime matches today’s date. Since TODAY() only returns the date, you need to convert … Read more >>>

Add Days to Date Using Salesforce Formula

How to add Day to Date in Salesforce Example

I was working as a system admin for a company that uses Salesforce to handle customer support cases. Every time a new case is created, the support team must follow up within 3 days after the case is created. Instead of manually calculating the follow-up date, we can create a formula field in Salesforce that … Read more >>>

Convert Date to Text Using Formula in Salesforce

Salesforce Classic Example Date to Text Advance Formula

In Salesforce, Date fields always show in standard date format, like YYYY-MM-DD. But sometimes, we need the Date in Text format for emails or reports. Salesforce does not directly allow us to change Date to Text without using a formula. For example, if we are sending an email and want to include the Date field, … Read more >>>

Salesforce Formula to Get Last Day of The Month

Salesforce Formula to Get Last Day of the Month

In Salesforce, we sometimes need to determine the last day of a month based on a given date. For example, if a campaign has an End Date of 21st August 2025, we may want to know the 31st August 2025 (the last day of that month). Salesforce does not provide a standard field to display … Read more >>>

live webinar

Build Your First Agentforce AI Agent in Salesforce

We will show demo on the complete process of building your first AI Agent in Salesforce using Agentforce. You’ll learn how agents work and how to connect your agent to Salesforce data to deliver intelligent business outcomes.

Agentforce in Salesforce

DOWNLOAD FREE AGENTFORCE EBOOK

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