Loading

TEXT and ISBLANK report formulas return different results in reports than at the record level

Udgivelsesdato: Jun 18, 2026
Beskrivelse

In Salesforce Reports, when displaying formula fields that combine the TEXT() and ISBLANK() functions on a Date or Date/Time field, there may be inconsistencies between the report's results and the values displayed on the records themselves.
Examples:

  • A record displays a FALSE value for the formula field, but the report displays TRUE.
  • On the record, the field value appears blank. On the report, the formula returns "Z" — because that is how a null Date/Time value is stored in the database (as a UTC timestamp suffix).
Løsning

Workaround

To avoid inconsistent results between reports and record views, remove the TEXT() function from any formula that uses ISBLANK() on a Date or Date/Time field.
Why this happens: The TEXT() function converts a Date/Time value to a string, including the "Z" UTC timestamp suffix (for example, "2024-01-15T00:00:00.000Z"). This causes ISBLANK() to evaluate to FALSE even when the Date/Time field appears visually blank on the record — because the underlying database value is not an empty string; it is a formatted timestamp string.
The fix: Using ISBLANK() directly on a Date/Time field — without wrapping the field in TEXT() — produces accurate and consistent results in both the record view and reports.
Example before (inconsistent): ISBLANK(TEXT(CloseDate__c))
Example after (correct): ISBLANK(CloseDate__c)

Vidensartikelnummer

000386828

 
Indlæser
Salesforce Help | Article