KNOWLEDGE BASE

Date and Time field shows data in unexpected timezone when connecting to Salesforce CDP.

Published: 17 Feb 2023
Last Modified Date: 20 Feb 2023

Issue

When connecting to Salesforce CDP the date and time field shows data in unexpected timezone.
For example if your OS timezone is set to JST (Japan Standard Time, GMT+9), the date and time filed will show data in GMT+18.

This issue happens when:
  • Connecting to Salesforce CDP from Tableau desktop and using driver Salesforce-CDP-jdbc-1.17.0.jar.
  • Connect to Salesforce CDP from Tableau Cloud.

Environment

  • Tableau Desktop
  • Tableau Cloud
  • Salesforce CDP

Resolution

For Tableau Desktop user:
  Please use driver Salesforce-CDP-jdbc-1.16.0.jar instead.
  Driver could be downloaded from https://github.com/forcedotcom/Salesforce-CDP-jdbc/releases/.

For Tableau Cloud user:
  Use a calculation with the DATEADD() function to account for the time zone offset.
  For example. to convert GMT+18 back to JST (Japan Standard Time), using the following formula:

  • DATEADD('hour', -9, [Date and time fields])

Cause

This issue is under investigation by the development team.
Did this article resolve the issue?    
PRINT THIS PAGE
Trending Articles
Attachments


All Support

SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
INFORMATION
ASSISTANCE