8 Replies Latest reply: Jul 17, 2018 5:56 AM by Gabor Tarnoczai RSS

    Help me below requirement?

    chaitanya krishna

      Hi

       

      I have fields id and issue_creationdate and taregetdate

       

       

      Id    Issue_creation_date.    Tareget_date

      1.       07/10/2018.                07/15/2018

      1 .       07/10/2018.               07/14/2018

      2.        07/09/2018.              07/09/2018

      3.       07/09/2018.               07/11/2018

      3.      07/09/2018.                 07/10/2018

       

      My requirement is count issue id  the  when target date is changed.

       

      Example  above table id 1 first target date 07/14/2018 but that id target date change to 07/15/2018.

       

      So I need calculate issues id intial one targetdate and changed to another date.

       

      How to write the expression? Please help on this.

       

      Thanks