3 Replies Latest reply on Mar 1, 2017 10:48 AM by Nikunj Bhardava

    Need help with error: Oracle database error 1843: ORA-01843: not a valid month

    luciana.suran.1

      Hi,

       

      I am importing data from an Oracle database and I got the dreaded "Oracle database error 1843: ORA-01843: not a valid month" error. I looked up a bunch of similar posts on the Tableau forum, but I was wondering if it is possible to convert the date into an appropriate format using Custom SQL? I tried converting the date to a string using the TO_CHAR function but I still get the same error message.

       

      Thanks!!!