2 Replies Latest reply on Jul 10, 2017 1:31 PM by Richard Cheslo

    Split Date Range column into 2 results in ORA-01843: not a valid month when trying to convert to date

    Richard Cheslo

      My data Oracle data source has a column of date ranges such as "4/2/2017-4/9/2017'. I split the one column into two columns, so I can have a start date and an end date. However, when I try to change the data type of either of the two new columns from String to Date I get the ORA-01843 Error message.  I am not finding a compatible solution to correct this. All assistance is very appreciated. Thank you.