4 Replies Latest reply: Oct 14, 2014 8:50 AM by Aissam Boumejjane RSS

    intervalMatch problem

    Aissam Boumejjane

      Hi Guys,

       

      I have two tables: One table that contains the orderDate. And another table that has the ContractStartDate and ContractEndDate

      When I do a left join I see the orderDate, ContractDate and ContractEndDate.

      Now, when I use IntervalMatch to build the dates between, I null values.

       

      I really would like to know, why is it that the IntervalMatch does not work?

       

      Since an Order can have more than 1 contractdates, I used min and max functions to create 1 line per contract/supplier.

       

      Please have a look at my script.

      Looking forward for the solution .

       

      Regards,