Move date in calendar

Anonymous — Fri, 21 Jul 2017 12:29:01 GMT

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

Re: Move date in calendar

aarkay29 — Fri, 21 Jul 2017 13:22:40 GMT

instead of round (FileTime()) as Ldate

try

Date(Floor(FileTime())) as Ldate

Re: Move date in calendar

Anonymous — Mon, 24 Jul 2017 07:36:37 GMT

Thank you, I didnt know this function.

topic Move date in calendar in App Development

Move date in calendar

Re: Move date in calendar

Re: Move date in calendar