Intervalmatch exact date

[#1]

Hi guys,

I have a to dates in a intervall match call them StartDate and EndDate, then i have DoneDate that i match in this intervall.

But there is a issue. If StartDate is (2015-04-28) and EndDate is (2016-01-21) and DoneDate is (2015-04-28) the DoneDate wont show in the intervallmatch. All other dates match but not DoneDate that is the same date as StartDate.

Any solution to this?

thx Theo

[marcus_sommer · Accepted solution]

Normally are the boundaries from an intervalmatch included. This meant the 2015-04-28 should be included. Are your sure that you really handled with dates or are this timestamps. To ensure this you need to load your Start- and EndDate with:

date(floor(StartDate)) and date(floor(EndDate))

- Marcus

[#3]

Worked like a charm but i had to Floor all the dates not only in the intervallmatch. Thx