What is your Calc and what is the Error and what is your String Data?
In Impala "TIMESTAMP" function work for both date and time.
If you want to use date function in tableau, you can extract the data and then can use tableau date function.
Hello Meenu Choudhary,
Thanks much for the solution.
It worked when I create an extract and then convert it date.
Concern: There will be many instances where I need to change the extract to LIVE to modify the dashboard. As soon as I convert Extract to LIVE then the field which I converted from String to Date in Tableau becomes invalid because of this my entire dashboard gets broken.
So could you suggest how can I fix this please?
Thanks Meenu Choudhary. I tried as you suggested but still no luck.
Asking saravana.paramaramaraj ..As per my research on the forum, you're using Impala ODBC connection to develop Tableau dashboard.
Can you please advise how to convert string to date date type using custom SQL in Tableau?