2 Replies Latest reply: Dec 4, 2017 9:52 AM by Teis thrane Wamsler RSS

    Creating Master Calendar

    RAVI SHINGE

      Hello Guys,

       

      I have to create a master calendar .

      I have around 200 different projects with unique ids which has :-

      a. Start date

      b. End date

       

      I have to create a master calendar using auto generate . Kindly help me with this .

       

      My tables looks like this as shown below :-

      ID ProjectStart date(MMDDYYYY)End Date(MMDDYYYY)
      1202/02/2015 20/06/2019
      3430/07/201604/05/2018
      5626/04/201606/07/2019

       

      Along with master calendar , I also need to calculate difference between these two dates(End-Start) in months, days, years and so on.....

       

      Thanks In Advance,

      ravi