KNOWLEDGE BASE

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


Published: 05 Apr 2013
Last Modified Date: 20 Sep 2016

Issue

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

Environment

  • Tableau Desktop
  • Oracle

Resolution

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. 

Cause

The date format in Tableau Desktop does not match the date format in Oracle.
Did this article resolve the issue?