Last Modified Date: 10 Feb 2017
- Tableau Desktop 10.1.0
ResolutionUse the DATE() function instead of special formatting of an INT() or FLOAT() in order to convert an integer to a date.
CauseWrapping the date in INT() or FLOAT() converts the date to its corresponding epoch date which uses the underlying data source's epoch start ("0" date). Therefore, using special formatting of an INT() function to create a date will use a different method to calculate the date from the epoch date.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials