Issue
The following date formats are not recognized by Tableau Desktop:- Month_/Year: MMM-YY
- FY_Year: YYYY
Last Modified Date: 05 Oct 2017
Environment
Tableau DesktopResolution
Create calculated fields to convert the date formats into recognizable formats.
Option 1: [Month_/Year]
- From the Dimensions pane, right-click each field, and select Change Data Type > String.
- Select Analysis > Create Calculated Field.
- 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.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials