Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

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?

1 Answer

0 votes
by (47.2k points)
  • My date format

enter image description here

  • Change your format in string

enter image description here

  • Create custom calculation

MID([Date],6,2) + "/" + MID([Date],4,2) + "/" +MID([Date],2,2)

enter image description here

  • Change your data type to date

enter image description here

  • You date will look like this

enter image description here

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...