Issue
The following date formats are not recognised by Tableau Desktop:- Month_/Year: MM-YY
- FY_Year: YYYY
Last modified date: 24 Aug 2022
Environment
Tableau DesktopResolution
Create calculated fields to convert the date formats into recognisable 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 dialogue, 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 dialogue, 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 recognises 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