Loading

Data Cloud Date Fields Display Timestamp in CRM Analytics Dashboards

Veröffentlichungsdatum: May 1, 2026
Beschreibung

When creating CRM Analytics dashboards that consume data from Data Cloud data model objects, Date type fields display with an appended timestamp in the format T00:00:00Z. This is working as designed.

This behaviour occurs because, in the Data Cloud application, query executions are performed against the Data Cloud Query API V3 endpoint. In contrast, in CRM Analytics, query executions are performed against the Data Cloud Query API V1 endpoint, leading to the observed differences.

Historically, Query API V1 responses serialise both Date and DateTime fields similarly, including a .000Z (UTC) suffix in the returned JSON. This makes a Date field appear like an ISO-8601 timestamp (an international standard for date and time formats).

Lösung

Use the date_format() function in the CRM Analytics lens query editor to reformat the date field and remove the timestamp. The syntax is date_format followed by the field name and the desired format string, for example YY-MM-DD, to display only the year, month, and day.

Nummer des Knowledge-Artikels

005299180

 
Laden
Salesforce Help | Article