2 Replies Latest reply: Jul 24, 2017 3:36 AM by Daniel Kuba RSS

    Move date in calendar

    Daniel Kuba

      Hello,

      Im using in my srict function FileTime as base for my date. Each date I get three files, from this files I take my data. Then I made new field as Ldate. In sript its:

          [Movements]:

          LOAD

          FileTime(),

          round (FileTime()) as Ldate

       

      As my calendar Im using:

      MinMax:

      Load

      Min(Ldate) as MinDate,

      Max(Ldate) as MaxDate

      Resident [Movements];

       

      Let vMinDate = Num(Peek('MinDate',0,'MinMax'));

      Let vMaxDate = Num(Peek('MaxDate',0,'MinMax'));

       

      TempCal:

      Load

      DATE($(vMinDate)+RowNo()-1)as TempDate

      AutoGenerate

      $(vMaxDate)-$(vMinDate)+1;

       

      DROP TABLE MinMax;

       

      "Master Calendar":

      Load

      TempDate as Ldate,

          Year(TempDate) as Year,

          Month(TempDate) as Month,

          Week(TempDate) as Week,

          Day (TempDate) as Day,

         'Q'& Ceil(Month(TempDate)/3) as Quarter,

         Date (Monthname (TempDate),'YYYY-MM') as "Year-Month",

         Date (Weekname (TempDate)) as "Year-Week"

       

      Resident TempCal

       

      Order by TempDate ASC;

       

       

      But in Application I have two rows moved to Tomorrow. Example: Original and right one is 1.1.2017 for first three rows (in FileTime). But I got in Ldate two rows from three converted as 2.1.2017. (second Januar). Then all my datas is wrong moved two rows forward - and it is problem.

      Can anybody help me and tell me, where I made error? In added file is screen from application with wrong converted date. Thank you