IntervalMatch with Dates Inside

[Anonymous]

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

[Gysbert_Wassenaar]

Looks ok to me. What do you think is wrong?

[Anonymous]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[Anonymous]

That makes sense. Thank you a lot, Gysbert!