Convert month number to month (month period)

Options
Catheline
Catheline Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi,

 

I am looking for a way to convert a month number (f.e. 1) to month name (f.e. 'Jan 20'). 

How would you do this? 

 

Kind regards,

Catheline 

Tagged:

Comments

  • Catheline
    Catheline Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    Hi @paolovm,

     

    I like this idea!

     

    It avoids having to make an additional list.

     

    Thank you! 

  • nibandha
    nibandha Member, ALL USERS Posts: 3 New Contributor

    Hi,

    I have similar scenario, however, the month number will be based off a flag in the source system. 

    For example, we are getting a file from the source system which has bench_mnth which is a date - for example march 2021, jan 2021 etc. Based on that month, Month1, Month2, and Month3 would be mapped to later month. For example, if the bench_mnth is March 2021, then month1, month2, month3 would be Apr, May, June 2021.

    Any suggestions?

  • nibandha
    nibandha Member, ALL USERS Posts: 3 New Contributor

    @rob_marshall 

    Thanks for the quick response. 

    The bench month is not an issue as we can find out the month based on the rows, for example, 202103 is March. However, the amount for MTH01, MTH02,MTH03, would go to Months based on the Bench month. This is where my concern is. Of the two rows I have, the first one would go to APRIL, MAY, JUNE, however, the second one would go to FEB, MAR, APR.

    Any suggestion on how I can achieve it. Thanks.

  • nibandha
    nibandha Member, ALL USERS Posts: 3 New Contributor

    CC and GEO are not one-to-one. It is basically many to many, meaning Cone CC can have data against multiple and vice versa.

Categories