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

    Get Month Name from Number

    David Coad



      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