All Dates Show up as 1905

Published: 08 Mar 2013
Last Modified Date: 02 Jan 2019


After  you convert a year field, which Tableau recognizes as a measure, to a Date data type, all date fields have the year 1905.


  • Tableau Desktop
  • Excel


Create a calculated field to reformat the year integer into a date format that Tableau Desktop can understand:
  1. Right-click your date field in the Dimensions pane and select Change Data Type > String
  2. Select Analysis > Create Calculated Field.
  3. In the Calculated Field dialog box that opens, type a name for the field.
  4. In the Formula box, type the following formula: DATE("01/01/" + ([Year]))and then click OK.
  5. Use this new calculated field in the view instead of the date field.


When you import a field from Excel that contains only the year value(YYYY), Tableau recognizes the field as an integer rather than as a date. The date format recognized by Tableau is DD/MM/YYYY.

Did this article resolve the issue?