Forum Discussion

dilkushpatel's avatar
dilkushpatel
Icon for Helper III rankHelper 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
dilkushpatel's avatar
dilkushpatel
Icon for Helper III rankHelper 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
Icon for Community Admin rankCommunity 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