Month number shows month name incorrectly

[Anonymous]

Hi all,

Interested to know why the following calc column is showing the incorrect month name from month number. It is always one less than the actual month name

I extract text month number, convert to a number and then format that as month name. However month number 1 is converted to December, not January for example. The produce month name is always -1 the actual month.



Thoughts?

Many thanks,
J

[Greg_Deckler · Accepted solution]

With those FORMAT types, they are expecting a Date, not an integer number of the month

[Anonymous]

Thanks for the tip Greg. I created a dummy date to turn this into a date.
Cheers, J

[Greg_Deckler]

Yep, I've fallen into the same trap before and sat there for hours staring at the code before slapping myself in the forehead!!