The Difference Between Dateparts and Datetruncs – Tip Week

My 5th and final tip of the week looks at the difference between Dateparts and Datetruncs in Tableau.

The first thing to note here is that when you drag a date field on to the view, Tableau is essentially automatically calculating one of two things: datepart or a datetrunc.

So, how does Tableau decide which to use?

When you right-click and drag a date field on to the view, a box will pop up for you to choose what field you’d like to drop into the view. There are two main sections to this list (highlighted in yellow below) and one main differences between them… one section has blue symbols and the other has green.