KNOWLEDGE BASE

Data Update Time Displaying Incorrect Timezone When Published


Published: 14 Aug 2017
Last modified date: 07 Nov 2023

Issue

After publishing a workbook which utilizes the Data Update Time feature, the incorrect time-zone is displayed.

Environment

  • Tableau Server
  • Tableau Cloud

Resolution

Workaround:
In the title, UTC can be appended after <Data Update Time> to specify that the time is in UTC.
User-added image
Additional workaround:
  1. Open the workbook in Tableau Desktop 
  2. Create a custom calculated field according to the instructions in the following article, Date Calculations, Filters and Time Stamps Show Unexpected Results After Publishing
  3. Republish the workbook to Tableau Cloud.
Note: <Data Update Time> is not available to be used in a calculated field. In the above article, instead of a date field, use NOW() to approximate <Data Update Time> on a live connection. On an extracted connection, NOW() will not work as desired. However, for some data sources it may be possible to convert the connection to a custom SQL connection and add a CURRENT_TIMESTAMP field that will return the time the extract was created.
 

Cause

For workbooks published to Tableau Server or Tableau Cloud, the Data Update Time will use the system time from the operating system on the computer hosting Tableau Server/Tableau Cloud.

 

Additional information

System time for each Tableau Cloud environment: 
10ay: US Pacific 
10az: US Pacific 
US-East-1: UTC
Dub01: UTC

To voice your support for the future implementation of such a feature, please vote on the following ideas: Data Update Time - formatting and wider use


Discuss this article... Feedback Forum
Did this article resolve the issue?