3 Replies Latest reply: Jul 16, 2014 6:08 AM by jagan mohan rao appala RSS

    define fiscal year calendar in script with min & max date

      Hi guys

      I don't get a financial calendar

      I have following things:

       

      CONNECT TO XYZ;

       

      Load [Posting Date],

           Month([Posting Date]) as Month,

           Year([Posting Date]) as Year;

       

      SQL SELECT [Posting Date] FROM XYZ;


      My intention is to create a calendar with the financial section which is from October YEAR to septemer YEAR+

      It would be nice to create a FROM - TO calendar in to tables


      And my 2. lil question is: How can I fix the order of the Month ? with Match?

      Because in my database it starts from another date, not october ..


      Best regards, Tobias