Last Modified Date: 19 Oct 2019
- Tableau Desktop
- Tableau Server Repository (PostgreSQL database)
- Amazon Redshift
- Live connection to data source hosted on machine in different time zone
Use an extract. For more information, see Extract Your Data.
Use a calculation with the DATEADD() function to account for the time zone offset.
- To convert UTC to PST (Pacific Standard Time), the formula: NOW()
- Could become: DATEADD('hour', -8, NOW())
Note: During daylight savings time the time difference between UTC and PDT will be -7 hours.
To convert UTC to PST (Pacific Standard Time) for a relative date filter:
- Remove the date filter from the Filters shelf
- Select Analysis > Create Calculated Field
- In the Calculated Field dialog box that opens, do the following, and then click OK:
- Name the calculated field. In this example, the calculated field is named "Last 3 Days Filter"
- In the formula field, create a calculation similar to the following:
[Date Field] >= DATEADD('day', -3, DATEADD( 'hour', -8, TODAY() ) )
- Drag [Last 3 Days Filter] to the Filter shelf.
- In the Filter dialog, check True and click OK.
CauseWhen connecting live, Tableau Desktop queries the datasource for NOW() or TODAY(). If the data source is hosted on a machine in a different time zone, then the data source may return the time in that time zone.
Live connections to Redshift and PostgreSQL are designed to return UTC time due to inconsistencies in how these datasources handle datetime and time zone offsets.
To voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: Timezone conversion support.
Discuss this article...