FORMAT function giving wrong values

[dilkushpatel]

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

[procyon82]

Can you post your formula?

[dilkushpatel]

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 · Accepted solution]

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