2 Replies Latest reply on Oct 11, 2017 11:37 PM by haitham Farouk

    Convert Month Number To Month Name

    Jasmine Singha

      Hi,

       

      We want to get month name . we have used he below logic in the calculated field but it gives us month number

       

      if [Month/Day] = 'Day' then str(month([Calldate]))+ "/" + str(day([Calldate])) + "/" + str(YEAR([Calldate]))

      else Left(str(DATENAME('month',[Calldate])),3) + " " +str(YEAR([Calldate]))

      END

       

       

       

      Please guide.

      Thank you.