Excel should recognize it as a date field (convert it to a number, if it doesn't show something like 40995, then it's not an Excel date). If not you will have to convert it in Tableau or Excel using calculations.
Thanks Alex, can you you provide some direction in the case of needing to use a calculation to create those date fields.
1 of 1 people found this helpful
Very highly dependent on your current data. Very messy dates like 20110316 may end up with a calc like this (only an example, does not work on this date, this produces a date and time):
datetime(mid([End Date],3,2)+'/'+right([End Date],2)+'/1'+mid([End Date],2,1)+' '+left([End Time],2)+':'+mid([End Time],3,2)+':'+right([End Time],2))
Whereas if your date is sensibly formatted (January 2nd 2011) it could be as simple as:
date([Original Date Field])