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

Use one of the below workaround options

Option 1

Specify the Tableau Cloud system time-zone after the <Data Update Time> function.

User-added image

Option 2

Replace the Data Update Time function with a CURRENT_TIMESTAMP field from the dataset and calculation to specify the desired time time-zone.
  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.

 
Did this article resolve the issue?