2 Replies Latest reply: Sep 13, 2012 9:32 AM by Henric Cronström RSS

    fin_month?

      Hi,

       

      I am doing financila month name and month no.in edit script.My Financial year starts with Apr-Mar.

      Example:-Apr-2011 to Mar-2012 is my financial year 2012.

                      Apr-2012 to Mar-2013 is my financial year 2013.

       

      I  am using this,

       

      if(Num(Month(Date(date)))>3,Num(Month(Date(date)))-3,Num(Month(Date(date)))+9) as Fin_MonthNo,

      left(Monthsname(1,date,0,4),3) AS Fin_Month_Name,

       

      But it is showing only Jan month, monthno is 10.I dont know why it is showing only one month name and no.

      can any help me for correct syntex.

       

      regards,

      baru

        • Re: fin_month?

          Hi,

          can any help me this problem.

           

          regards,

          baru

            • Re: fin_month?
              Henric Cronström

              I would do it the following way: All you need to do is to replace the Transaction table with whatever you have.

               

              // ===== Some dummy transactions

              Transactions:

              Load

                        rand() as Amount,

                        Date(round(MakeDate(2008) - 1 + 1000*rand())) as date

                        autogenerate 1000;

               

              // ====== and a master calendar...

              Set vFirstMonthOfFiscalYear = 4;

              MasterCalendar:

              Load distinct *,

                        if(Month>FiscalMonth,Year & '/' & (Year+1), (Year-1) & '/' & Year) as FiscalYear;

              Load *,

                        Dual(Month,Mod(Month-$(vFirstMonthOfFiscalYear),12)) as FiscalMonth;

              Load

                        date,

                        Year(date) as Year,

                        Month(date) as Month,

                        Date(MonthStart(date),'YYYY MMM') as RollingMonth

                        resident Transactions;

               

              HIC