Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys!
I have following code:
[Test]:
LOAD
Date(25569+[start_epoch]/24/60/60) as StartEpoch,
Date(25569+[end_epoch]/24/60/60) as EndEpoch
FROM ...;
[Intervals]:
IntervalMatch (Date) //Date is stored in MasterCalendar Table
LOAD
StartEpoch,
EndEpoch
Resident [Test];
After loading the script I have the following situation:
Why do I have wrong matching of StartDate?
I know how I can fix it for further work. I'm asking about the correct explanation of this issue.
Thank you
Elena
Then you should make sure you're working with dates and not timestamps. 18/01/2016 12:34:56 is larger than 18/01/2016.
Looks ok to me. What do you think is wrong?
Hey, Gysbert!
I thought that if i have 18/1/2016 as StartDate, then the interval should be 18/1/2016, 19/1/2016 and 20/1/2016. The same as we write it: 18/1/2016-20/1/2016 means 3 days period, but not 2. I expected to have same result.
Elena
Then you should make sure you're working with dates and not timestamps. 18/01/2016 12:34:56 is larger than 18/01/2016.
That makes sense. Thank you a lot, Gysbert!