Are you trying to take a date and make it a numeric field.
Or take a number field and make it a date?
or Neither of those? What is your expected output. Could you show us a picture of the data and the error message in the calculation as well?
1 of 1 people found this helpful
If you are unable to change the data type within Tableau, worst case scenario is that you can use a calculated field to parse the text field into a date field. Assuming all dates are formatted as mm/dd/yyyy, you can use:
Does this help?
It worked! Thanks a lot Michael
I had to parse the text field since when I changed the data to date, I got null values. Thank you for your response!