Loading

Filter Blank Value of a Date Field in Dashboards

Publish Date: May 5, 2026
Description

When a dashboard needs to surface records where a Date field has not been filled in — for example, Contacts without a Birthdate or Cases without a Close Date — a special filter configuration is required, as blank date values cannot be selected through the standard date picker.

Resolution

Let's create the filter in the dashboard - 

1. Click Edit button. 
2. Click + Filter button. 
3. Input in the Field: Birthdate.
    Display name: Birthdate
    Filter values click New Filter Values
4. Operator: select "Equals".
    Date type: select "Relative"
    Value: enter "" (If no input, apply button is disable) 
    Display Text. input Blank Birthdate
    Click Apply button. 

Screenshot showing the Dashboard filter configuration panel with the Birthdate field selected, the Equals operator chosen, the Relative date type set, and an empty value entered to capture blank dates."

5. Click Add button. 
6. Click Save button, and Done button. (Client can view Contacts record with a blank birthdate in the dashboard.)


Note: If you want to edit Display Text, please start again from step 4. 

 

Knowledge Article Number

000392585

 
Loading
Salesforce Help | Article