Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Worked like a charm but i had to Floor all the dates not only in the intervallmatch. Thx