QUESTION: How do I format a Month Number to a Month Name?
ANSWER: Most of our date conversions come directly from a date. If given just the month number, however, you must first convert the number into a valid date format and then you may use the FormatDate() function to convert the date into your preferred format.
To convert a month number into a month name: = FormatDate(ToDate(+”/1/2004″,”m/d/yyyy”),”Mmmm”)
To convert a month number and year combination into the format of periods as they appear in many modular databases such as Oracle Financials: