Last Modified Date: 12 Apr 2018
ResolutionTo ensure Tableau treats the results of the DATEPART as desired, either change the field type to Date, or use DATETRUNC instead of DATEPART.
CauseThis behavior is as designed. By default, the results of a DATEPART will be in a numerical format (e.g., integer). The behavior of date formatting for number fields is different from the behavior of date formatting for date fields.
Additional InformationFor additional information about dates, see the following topics in Tableau Help:
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials