4 Replies Latest reply on Mar 25, 2018 10:06 PM by vikas chowdary

    Datename function is returining number

    vikas chowdary

      Hi All,

       

      DB2 is the current database which I have connected to Tableau for my visualization. After connecting to DB2 "Datename" function is returning number instead of a string.

       

      Eg:

       

      Datename('month', 10/24/2016) is giving me 10 instead of December.

       

      It was working fine when we connected it to data in Excel. we have changed our data source from excel to DB2 and from then we are facing this issue.

       

      Is it compatibility issue between DB2 and Tableau? If so what is the solution.