Hey John -

We store timestamps in UTC in the base tables. Our reports (like the admin reports on the "Maintenance" page) figure out the offsets automatically. However, if you go directly to the base views/tables yourself, it's up to you to add / subtract your UTC offset based on what timezone you're in.

Good luck!

hi Russell Christopher,

Need some clarification  on the statement:

"Our reports (like the admin reports on the "Maintenance" page) figure out the offsets automatically"

So Is there a Calculation or Tableau Server takes care of the Offset ( including Day light savings) based on the Server location?

If Tableau Server takes care of it  why do we need t o "add / subtract UTC offset based on what timezone I am in."

thanks!

Deepak Ujania

The Tableau Server admin reports which you consume from the Tableau Portal does the time offset work.

This thread is talking about consuming data directly from the Tableau database tables, before the date/time values are massaged by our admin reports.

Therefore, you need to massage.