CALENDAR TO MONTH ?

[Anonymous]

i have calender jan as 1st month & dec as 12th month

but i want to get the output as july as 1st month & oct as 12th month  how ?

[PrashantSangle · Accepted solution]

Hi,

Create Inline table

LOAD * INLINE[

MonthName,Month

July,1

Oct,12

...

...

..

];

Regards

[sagarkharpude]

Try this in sort tab->Expression

=wildmatch(Monthfield,'Jul','Aug','Sep',              'May','Oct')

or create the inline table as follows in script:

load * inline

[

monthname,monthnumber

Jul,1

Aug,2

Oct,12

];

[avinashelite]

hi

you can try to set it  in the edit script by the setting the set statements

SET MonthNames='Jul;Aug;Sep;Okt;Nov;Dez;Jan;Feb;Mrz;Apr;Mai;Jun';

or

Create a calender of your own

[#5]

Hi,

If you are trying it in script.

load * inline

[

monthname,monthnumber

Jul,1

Aug,2

Oct,12

];

[hic]

You should create a master calendar of your own. See e.g. this blog post: Fiscal Year.

You should NOT change the environment variable in the script (The "SET MonthNames=" statement) since you then will rename the months, i.e. you will get the 'July' label for the month of January. No, you should use

   Mod(Month-$(vFM), 12)+1        as MonthNo

to calculate a fiscal month number in addition to the Gregorian (the real) month number. The vFM variable is the number for the first month of the fiscal year.

HIC