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:




      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