How to convert a timezone to a different timezone with a function in Tableau?
- Tableau FAQs
- December 12, 2018
Let’s say you have CST (UTC + 6) and need to change that to GMT + 11 (Australian Time). Australian time is 17 hours ahead of CST, so we can use the DATEADD function to add 17 hours to CST:
DATEADD(‘hour’, 17, [Modified Date])
‘hour’ – this is a mandatory condition; here, we specify the date type, time, hour, minute, and so on.
17 – since we specified ‘hour,’ we need to specify the number of hours. Here we indicate 17 hours, this is a positive value, but if you need to specify a negative value, then we can specify -17, then the time zone will change from 17 hours and forward to 17 hours ago.
[Modified Date]) – this is the date with which to use to change the time zone
