2 Replies Latest reply on Dec 7, 2016 5:38 AM by Tom W

    Facing Issue to convert string month value into number

    Arti Singh

      Hi Experts,

       

      I am facing issue to convert String into Number in Tableau . My data base is Sql Server.

       

      In my Database has Date_Month Column . And having value  are below mention like this

       

        Date_Month

      January
      February
      March
      April
      May
      June
      July
      August
      September
      October
      November
      December

       

      Now i want to convert Date_Month value into number like January =1 and February =2 so on.

       

      January1
      February2
      March3
      April4
      May5
      June6
      July7
      August8
      September9
      October10
      November11
      December12

       

      Please help me on this.

       

      Thanks,

       

      Arti