Data Cloud Date Fields Display Timestamp in CRM Analytics Dashboards

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).