3 Replies Latest reply: Mar 13, 2017 5:50 AM by Reinhold Graf RSS

    Creating Mastercalendar (only month-end dates)

    Reinhold Graf

      Hi.

       

      I use the following approach to create a MasterCalendar:

       

       

      //--------------------------------------------------------//

      //----- MasterCalendar für Lagerbestand -----//

      //--------------------------------------------------------//

      [Datum_LB]:

       

       

      // Datumsfelder zusammenstellen

      LOAD

          "%TempDatum" AS "%LB_Datum", // Datum;

         

      // TempCalendar erstellen

      LOAD

        Date(mindate + IterNo(), 'YYYYMMDD') AS "%TempDatum",

        maxdate

      While mindate + IterNo() <= maxdate;

       

      // Min/Max-Datum holen

      Load

        min(FieldValue('%LB_Datum', recno()))-1 as mindate,

          max(FieldValue('%LB_Datum', recno())) as maxdate

      AutoGenerate FieldValueCount('%LB_Datum');

       

       

      Incoming Data only has month-end dates, so that all the other dates inbetween, created in the MasterCalendar, are obsolete.

      Does anyone have an idea how to solve this problem ?

       

      Reinhold