1 Reply Latest reply: Nov 24, 2015 1:07 AM by Gysbert Wassenaar RSS

    How to create a interval match with master calendar?

    Jim Chan

      Hi there,

       

      I have a table - which have 2 datefield - Begin_Eff_Date & End_Eff_Date. Then, i do have transaction tables that have 1 one date field - transaction_date.

       

      I am planning to use master calendar, but problem is how can i make Begin_Eff_Date and End_Eff_Date to 1 date field and transaction table into 1 date field , then link it to the master calendar?

       

      some has told me about intervalmatch, but i don;t know how it works on my master calendar creation...

       

      Rgds,

       

      Jim