Loading

Filter Blank Value of a Date Field in Dashboards

Publiceringsdatum: Aug 18, 2026
Beskrivning

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.

Lösning

This article explains how to create a dashboard filter that surfaces records with a blank Date field value, since blank dates can't be selected through the standard date picker.

Steps to Create the Filter

  1. Click the Edit button.
  2. Click the + Filter button.
  3. In the Field input, select Birthdate.
    • Display name: Birthdate
    • Under Filter values, click New Filter Values.
  4. Configure the filter values:
    • Operator: select Equals.
    • Date type: select Relative.
    • Value: leave blank / enter "" (the Apply button stays disabled without input).
    • Display Text: enter Blank Birthdate.
    • Click Apply.

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.

  1. Click the Add button.
  2. Click Save, then Done. Contacts with a blank Birthdate will now appear in the dashboard.

Note

To edit the Display Text after saving, start again from step 4.

Knowledge-artikelnummer

000392585

 
Laddar
Salesforce Help | Article