I have been searching some solution for this kind of conversion issue in tableaue desktop 9.2. My source system is hadoop. I am getting some site related data from Hadoop and date field coming as string like "yyyy-mm-dd". I have tried all the options but could not get rid of null value issue.
tried extract instead of live and use date function or dateparse( it says not supported ) and left ,right ,mid function and concatenate and convert to date but got error even doing that. I got same null values while writing custom sql, so now not having any option . Please help me.I am newbie in this area.
Can you attach a packaged workbook with just a sample of the date values and your calculated fields where you are parsing the string into date values? (no confidential data is needed.) There is likely a problem in your usage of the string parsing or date conversion functions.