4 Replies Latest reply on Feb 21, 2018 4:33 PM by Sujay Paranjpe

    Problem changing number to date

    David Matthews

      I am using a db and there is a field called YEARMONTH which has YYYYMM format. When I bring it into tableau it shows as number format. I tried changing the data type in the datasource tab to DATE but Tableau doesn't return it in the same year month. Any suggestions on how to do this conversion to date type? The first image shows what the data looks like when I first bring the table over. The second shows what it looks like after I click the # and change it to DATE. As you can see it isn't right.

       

      YEARMOasNumber.PNGYEARMOasDate.PNG