11 Replies Latest reply: Jan 6, 2016 11:02 AM by Bill Markham RSS

    Intervalmatch- two event in one interval

    Amit Sharma

      Hi,

       

      I have table with from_date1,to_date1 and from_status. I have created one calendar for all dates.

      Now I used IntervalMatch for creating table which will give status and calendar date.

      from_status, to_status, from_date,to_date

      Open,            Closed,    01/01/2016,01/01/2016

       

      After Interval Match

      calendar date, from_status,from_date,to_date

      01/01/2016,    Open,           01/01/2016,01/01/2016

      01/01/2016,    Closed,         01/01/2016,01/01/2016

       

      Required:

      calendar date, from_status,from_date,to_date

      01/01/2016,    Closed,         01/01/2016,01/01/2016

       

      for one date, Status got changed from Open to Closed so for this event, It is showing two entries in table which is correct but I want to show only second status (Closed) for that date