1 of 1 people found this helpful
Don't change it to Date in the pivot window, import as text, which appears to work.
Once you have the text version within Tableau you can use a MAKEDATE or a DATEPARSE to convert it to a date to use within your dashboards.
2 of 2 people found this helpful
Yeah Andrew is correct. Using DATEPARSE() you can get the correct output. Let it be your pivot Date as string and use below calculated field.
Thanks! It worked.