KNOWLEDGE BASE

All Dates Show up as 1905


Published: 08 Mar 2013
Last Modified Date: 04 Oct 2017

Issue

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

Environment

  • Tableau Desktop
  • Excel

Resolution

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.

 

 

Cause

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?