3 Replies Latest reply: Sep 14, 2017 1:41 AM by zahid Rahim RSS

    Date Filter - Best Approach

    zahid Rahim

      Dear Experts,

       

      If we have date fields in 2 tables then what is the way to handel it in a filter?

       

      Suppose we have 2 tables

       

      Sales

      -----------------

      Region_Id

      Business_Id

      Transaction_date

      Sales Amount

       

      Target

      -----------------

      Region_Id

      Business_Id

      Target_date

      Target Amount

       

      What is the best way to join above two tables that no synthetic key should created and how to handel the date filter that both tables should show data as per the date filter.

       

       

      Best Regards,

       

      Zahid Rahim