Loading

Certain Date Formats Not Recognized by Tableau

Publiseringsdato: Apr 13, 2024
Beskrivelse
The following date formats are not recognized by Tableau Desktop: 
  • Month_/Year: MMM-YY
  • FY_Year: YYYY

 

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.
Løsning
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])
Knowledge-artikkelnummer

001473549

 
Laster
Salesforce Help | Article