convert Month number to Month Name

building reports webintelligence
1

Hi all

I have a month number , how do I convert this to a Month Name… eg. month no is 11, so would like month to be November… any help will be great

thanks

Sims786 (BOB member since 2006-04-04)

2

E.g. Use a convoluted, nested IF… THEN… ELSE… statement or… ask your universe designer to provide this instead.

Andreas :de: (BOB member since 2002-06-20)

3

I use the following formula for this:

=Month(ToDate("01/"+If([Month]<10;Concatenation("0";[Month]);[Month])+"/2011";"dd/MM/yyyy"))

…this tests for a single digit month and prefixes a zero if found - you get the idea. The end result date is completely irrelevant, all it’s doing is creating a valid date containing your month number and returning the Month name for this date.

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)