I have a data set with date format (which according to our IT it's an IBM format) 1110101 which means 1/1/2011, so 1160506 means 5/6/2016. I tried to convert it to date format that tableau can recognize and here's the plan:
Step 1, I create a field called "Date Converted"= Date I have + 19000000 Step 2, I use DATEPARSE to convert it to date by:
DATEPARSE("yyyymmdd",19000000+[Date I have])
But Tableau doesn't accept DATEPARSE and it says it's an unknown syntax. Anyone know's how to correctly convert IBM date format to a date that Tableau can recognize?