6 Replies Latest reply: Mar 18, 2011 2:32 AM by Sunil Jain RSS

Get Month Name from Number

David Coad

Hi,

 

I have this formula for the report name that uses the most recent month selected as part of the report name.

nb: MonthName is just that the name of the month e.g. Nov-11, when the range July to November are selected the formula:

 

 

=

max(total MonthName) & ' YTD Customer Report'

returns "11 YTD Customer Report". I want it to say "Nov YTD Customer Report".

How do I change my formula to get the name of the month not the number

Thanks

Dave