KNOWLEDGE BASE

Data Update Time Displaying Incorrect Timezone When Published


Published: 14 Aug 2017
Last Modified Date: 03 Dec 2018

Issue

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

Environment

  • Tableau Server
  • Tableau Online

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 Online.
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 Online, the Data Update Time will use the system time from the operating system on the machine hosting Tableau Server/Tableau Online.

 

Additional Information

System time for each Tableau Online 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
Did this article resolve the issue?