26 Replies Latest reply: Dec 1, 2017 2:15 AM by Sunny Talwar RSS

    Compare.

    Agrim Sharma

      Hi all,

      I have some topics which has Actual Start , Actual End dates and Planned start and planned End dates,

       

      I want to check the status of topics quarterly, whether the topic is started or not,

      that means:-

      I have to select current quarter(Oct. Nov. Dec.) from Planned Start and then I have to compare it with Actual Start For which I have to select from today date to 31st Dec or blanks.

         

      TopicP. StartA. Start
      a1-Dec-201722-Dec-2017
      b23-Nov-201724-Nov-2017
      c11-Oct-201721-Oct-2017
      d14-Jan-201817-Jan-2018
      e12-Feb-201822-Feb-2017
      f11-Nov-201711-Nov-2017
      g10-Oct-201713-Oct-2017
      h1-Jan-20182-Feb-2018
      i2-Feb-20172-Feb-2017
      j23-Mar-201724-Mar-2017
      k22-Apr-201824-Mar-2017
      l17-Oct-201729-Nov-2017
      m11-Dec-201730-Nov-2017
      n12-Feb-201714-Feb-2017
      o22-Dec-201723-Dec-2017
      p21-Nov-201730-Nov-2017

       

       

      Desired Result- 5

         

      TopicP. StartA. Start
      a1-Dec-201722-Dec-2017
      l17-Oct-201729-Nov-2017
      m11-Dec-201730-Nov-2017
      o22-Dec-201723-Dec-2017
      p21-Nov-201730-Nov-2017

       

      please help how can i achieve this, i have made and calendar for all date fields.