Solved: FORMAT function giving wrong values

dilkushpatel · ‎10-09-2015

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

WillT · ‎12-22-2015

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

View solution in original post

procyon82 · ‎10-09-2015

Can you post your formula?

dilkushpatel · ‎10-11-2015

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 · ‎12-22-2015

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