3 Replies Latest reply: Mar 2, 2012 5:17 PM by Matthew Fryer RSS

    How to Join tables with comparing dates?

      Hello,

       

      I tried looking for this but could not find a solution. I have two tables that I need to join, but I have to check if the date of the sale's table is between the date of the collection's table. In addition, the brand and category must be the same in both tables.


      Sales:
      Load  Date     
               Brand
               Invoice
               Category
               Material
               Sales

       

      The other table

       

      Collections:
      Load [Date start]
              [Date end] 
              Brand
              Category   
              Collection


      The result that I want is :

       

      Load  Date     

               Brand

               Invoice

               Category

               Material

               Sales

               Collection

       

      First of all, I thought in a left join but my big issue is manage with dates.

       
      How do I do this in Qlikview?