This content has been marked as final.
Show 2 replies
-
1. Re: Split Date Range column into 2 results in ORA-01843: not a valid month when trying to convert to date
Tom WJul 10, 2017 1:23 PM (in response to Richard Cheslo)
1 of 1 people found this helpfulIt 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))
-
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!