Forum Discussion
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
- 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
Can you post your formula?
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")
- 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
