Month number from Month Name in FCC — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Month number from Month Name in FCC

edited Aug 20, 2024 8:42AM in Financial Consolidation and Close 18 comments

I am trying to derive month number from Month name (example, 1 for Jan, 2 for Feb etc.) using below member formula but not able to get the expected results when retried.

Is there any rule which I am breaking?

IF(@ISMBR("FCCS_Periodic"))
IF(@CURRMBR(Period)=="Jan")
1;
ELSEIF(@CURRMBR(Period)=="Feb")
2;
ELSEIF(@CURRMBR(Period)=="Mar")
3;
ELSEIF(@CURRMBR(Period)=="Apr")
4;
ELSEIF(@CURRMBR(Period)=="May")
5;
ELSEIF(@CURRMBR(Period)=="Jun")
6;
ELSEIF(@CURRMBR(Period)=="Jul")
7;
ELSEIF(@CURRMBR(Period)=="Aug")
8;
ELSEIF(@CURRMBR(Period)=="Sep")
9;
ELSEIF(@CURRMBR(Period)=="Oct")
10;
ELSEIF(@CURRMBR(Period)=="Nov")
11;
ELSEIF(@CURRMBR(Period)=="Dec")
12;
ENDIF;
ENDIF;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!