Salesforce Formula Field to Check Null Values for Dates

Updated by

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. We will see the Salesforce formula field to check null values for dates in Salesforce.

Salesforce Formula to Check the Date Field is Null

We track various activities in Salesforce, such as when a record is created, when a payment is due, or when a task is modified, and for all such activities, we utilize date fields.

We developed an advanced formula to determine whether a date field is null or not. Essentially, it facilitates the smooth operation of business processes, enables accurate data analysis, and ensures data standards are maintained.

To check if a date field is null, we utilized the ISBLANK function of Salesforce. And by default, if the entered date field is null, this function returns a boolean value of true; otherwise, it returns a value of false.

Here is the syntax to check if a date field is null in a formula field:

ISBLANK(Date_Field)

In the above syntax, Date_Field is the API name of the date field that we want to check if it is blank.

Let’s understand this concept with the help of an example:

Suppose we are working as a sales manager, and we are responsible for monitoring Salesforce Leads. One day, we noticed that some of the leads were missing a Close Date.

To confirm this, we decided to identify if any of the Close Dates are null. So, for this, we create an advanced formula given below:

IF(ISBLANK(CloseDate), "Lead Miss the Close Date", "Lead Has Close Date")

With this, we now know about the Salesforce formula to check if a date field is null. Next, we will proceed to learn how to check if the date field is null in Salesforce Lightning.

Check If the Date Field Is Null in Salesforce Lightning

Here are the steps to define a formula that checks if the date field is null in Salesforce Lightning:

  1. Click the Setup icon in the top right corner of the page to access Salesforce Setup.
    • Click Object Manager