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 Jul 10, 2017 1:05 PM

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.

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

Tom W Jul 10, 2017 1:23 PM (in response to Richard Cheslo)

It could be a problem with a leading / trailing space. Perhaps give the DATEPARSE function a shot - http://onlinehelp.tableau.com/v10.3/pro/desktop/en-us/help.htm#data_dateparse.html#dateparse

DATEPARSE("MM/dd/yyyy",trim(Branch Invoice Schedule - Split 1))
1 of 1 people found this helpful
Like Show 1 Likes(1)

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

Richard Cheslo Jul 10, 2017 1:31 PM (in response to Tom W)

Thank you Tom - The DATEPARSE did the trick since the column was already trimmed during the split. I had tried the DATEPARSE before posting, but I had the syntax wrong even though it said it was a valid calculation. Thanks again for point the way!
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community

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

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

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

Actions

More Like This