topic Re: Intervalmatch exact date in QlikView https://community.qlik.com/t5/QlikView/Intervalmatch-exact-date/m-p/1148911#M375677 <HTML><HEAD></HEAD><BODY><P>Worked like a charm but i had to Floor all the dates not only in the intervallmatch. Thx</P></BODY></HTML> Mon, 22 Aug 2016 12:06:30 GMT 2016-08-22T12:06:30Z Intervalmatch exact date https://community.qlik.com/t5/QlikView/Intervalmatch-exact-date/m-p/1148909#M375675 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a to dates in a intervall match call them StartDate and EndDate, then i have DoneDate that i match in this intervall.</P><P></P><P>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.</P><P></P><P>Any solution to this?</P><P></P><P>thx Theo </P></BODY></HTML> Mon, 22 Aug 2016 11:36:13 GMT https://community.qlik.com/t5/QlikView/Intervalmatch-exact-date/m-p/1148909#M375675 2016-08-22T11:36:13Z Re: Intervalmatch exact date https://community.qlik.com/t5/QlikView/Intervalmatch-exact-date/m-p/1148910#M375676 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P>date(floor(StartDate)) and date(floor(EndDate))</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 22 Aug 2016 11:46:28 GMT https://community.qlik.com/t5/QlikView/Intervalmatch-exact-date/m-p/1148910#M375676 marcus_sommer 2016-08-22T11:46:28Z Re: Intervalmatch exact date https://community.qlik.com/t5/QlikView/Intervalmatch-exact-date/m-p/1148911#M375677 <HTML><HEAD></HEAD><BODY><P>Worked like a charm but i had to Floor all the dates not only in the intervallmatch. Thx</P></BODY></HTML> Mon, 22 Aug 2016 12:06:30 GMT https://community.qlik.com/t5/QlikView/Intervalmatch-exact-date/m-p/1148911#M375677 2016-08-22T12:06:30Z