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

    Move date in calendar

    Daniel Kuba


      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:




          round (FileTime()) as Ldate


      As my calendar Im using:



      Min(Ldate) as MinDate,

      Max(Ldate) as MaxDate

      Resident [Movements];


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

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




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




      DROP TABLE MinMax;


      "Master Calendar":


      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