My Oracle Support Banner

How To Return The Month Name? MonthName Function Returns the Month Number (Doc ID 2737592.1)

Last updated on DECEMBER 24, 2020

Applies to:

Oracle Fusion Loyalty - Version 11.13.20.07.0 and later
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion CX Sales Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion B2B Service Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.

Goal

The MonthName function that should return the name of the month for data provided. However, it is currently returning the number of the month.

To recreate the scenario:

  1. Navigate to BI Analytics
  2. Create a new analysis with a new subject area. For example, use "Sales - CRM Pipeline"
  3. Add "Opportunity"."Created Date"
  4. Edit Formula field and change the formula to: MONTHNAME("Opportunity"."Created Date")

For example, if the Created Date is 12/15/2020, customer expects to return December. However, it returns 12.

How to display the month name?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.