Loading

Filter Blank Value of a Date Field in Dashboards

게시 일자: May 5, 2026
상세 설명

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.

솔루션

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 기사 번호

000392585

 
로드 중
Salesforce Help | Article