1 Reply Latest reply: Apr 4, 2016 8:39 AM by Sunny Talwar RSS

    How can I do a Master Calender for multiple date fields in a single original table?

    John Blomqvist

      Hi all,

       

      How can I do a Master Calender for multiple date fields in a single original table?

       

      Example:

       

      TableA:

      OrderID,

      ItemNo

      Quantity

      OrderDate,

      Value,

      DueDate,

      Discount

      From TableA

       

      The above table has two date fields OrderDate and DueDate.

       

      I assume doing two Master Calenders, one for each date field would not be a great solution.

       

      Are there any better alternatives?