Forum Discussion

dilkushpatel's avatar
dilkushpatel
Helper III
10 years ago
Solved

FORMAT function giving wrong values

Hi,

i'm using format function and giving month number as input, where month number is 1 it is giving December as output.

Any idea what could be going wrong here?

 

Thanks,

Dilkush

 

Need Help
  • WillT's avatar
    WillT
    10 years ago
    Hi Dilkush. What output format are you trying to get? If you want the name of the month, this formula will work: FORMAT([datetime], "mmmm") You don't need the month() function as well. Hope that helps! Will

3 Replies

    • dilkushpatel's avatar
      dilkushpatel
      Helper III
      10 years ago

      format(month(date),"mmmm")

       

      I also used another way where first i created column which will hold month values and then use

       

      format(<column which has month number>,"mmmm")

      • WillT's avatar
        WillT
        Community Admin
        10 years ago
        Hi Dilkush. What output format are you trying to get? If you want the name of the month, this formula will work: FORMAT([datetime], "mmmm") You don't need the month() function as well. Hope that helps! Will