forums

Use these forums to ask questions and discuss Tableau.

What date format standard does Tableau use?

Posted December 6th, 2007 by Samantha Tack
in Dates & Times

I am working a lot with dates and times, specifically with week numbers. I am wondering what standard Tableau uses to determine the week number. That is, does Tableau use ISO 8601, which uses Monday as the first day of the week and the first week includes the first working Thursday; or is there another standard that it uses?

Thanks!

Add new comment

Comments

On December 6th, 2007 Erin Easter said:

Samantha,

The computation to determine week number is actually passed to the data source that you are using. That means if your data source adheres to the ISO 8601 standard then Tableau will too. For example, I know that SQL Server doesn't adhere to the ISO 8601 standard.

This is true for many types other types of computations as well. Specifically, dates and date part computations in Tableau are computed by the data source.

Hope that helps!

reply