1 Reply Latest reply: Sep 8, 2018 11:40 AM by Vu Nguyen RSS

    Need Help to convert Master calendar code to fiscal year calendar which is starting from April

    Priyal Paithankar

      Hi All,

      Below is my master calendar code.

      Please help me to convert this code to Fiscal Year master calendar which is starting from the Month April.

       

      temp_date:

      Load

      min(DocDate) as start_date,

      Max(DocDate) as end_date

      Resident All;

       

       

      Let vstart_date=peek('start_date',0,temp_date);

      Let vEnd_date=peek('end_date',0,temp_date);

       

       

      Master_Calendar:

      Load

      date_id as DocDate,

      num(Month(date_id)) as DocMonth,

      Year(date_id) as DocYear;


      Load

      $(vstart_date)+IterNo()-1 as date_id

      AutoGenerate 1 while($(vstart_date)+IterNo()-1<=$(vEnd_date));

       

       

       

      Thanks,

      Priyal.