KNOWLEDGE BASE

Certain Date Formats Not Recognized by Tableau


Published: 21 Jan 2013
Last Modified Date: 21 Jan 2017

Issue

The following date formats are not recognized by Tableau Desktop: 
  • Month_/Year: MMM-YY
  • FY_Year: YYYY

 

Environment

Tableau Desktop 

Resolution

Create calculated fields to convert the date formats into recognizable formats. 

Option 1: [Month_/Year]

  1. From the Dimensions pane, right-click each field, and select Change Data Type > String.
  2. Select Analysis > Create Calculated Field.
  3. In the Calculated Field dialog, do the following:
  • For the name, type Month/Year.
  • Enter the below formula, and click OK
DATE(RIGHT([Month_/Year], 2) + "-" + LEFT([Month_/Year], 3) + "-" + "01")

Option 2: [FY_Year]

Select Analysis > Create Calculated Field.
In the Calculated Field dialog, do the following:
  • For Name, type Year.
  • Enter the below formula and click OK.
DATE("01-01-"+[FY_Year])

Cause

This issue may occur for the following reasons:
  • Tableau only recognizes certain date formats automatically. For more information, refer to Supported Date Formats article. 
  • Sometimes when connecting to an Excel data source, the column format needs to be changed to "Text" or "General" in Excel.
Did this article resolve the issue?