Loading

Error "ORA-01843: Not a Valid Month" Creating Calculated Field in Tableau Desktop

Publiceringsdatum: Mar 17, 2026
Beskrivning
When you try to create a calculated field that uses the DATE() function, the following error might occur:
 
ORA-01843: Not a Valid Month

Cause

The date format in Tableau Desktop does not match the date format in Oracle.
Lösning

Option 1: 

Change the format of the string argument to the Tableau DATE() function to match the date format in your Oracle database.

 

Option 2:

Extract the data. For more information, see Creating an Extract in Tableau Help. 

 

Ytterligare resurser
  • This error is generated by Oracle and passed through to Tableau Desktop.
  • When using a Tableau data extract, Tableau Desktop does not need to communicate with the underlying Oracle database to find the matching string.
  • Community Forum: ORACLE/PLSQL: ORA-01843 ERROR

 

Knowledge-artikelnummer

001473616

 
Laddar
Salesforce Help | Article