7 Replies Latest reply: Jul 28, 2017 12:22 PM by Sunny Talwar RSS

    Calculation between dates

    FERNANDO RODRIGUES

      Hello.

       

      I am trying to calculate a value between dates.

       

      The information I have is as follows, No. of Contract, Beginning of Contract, End of Contract.

      Objective, know how many contracts are active in a given month, or day.

       

      No. of ContractBeginning of ContractEnd of Contract
      12301/04/201731/12/2017
      45601/01/201730/04/2017
      78931/12/201731/12/2018

       

      In the table above I would have;

      April month; 2 active contracts (Contract 123 and 456)

      01/05/2017; 1 Contract assets (Contract 123)

      01/01/2018; 1 Active contract (Contract 789)

       

      Can anyone help me out with the solution

       

      Thank you

      Fernando Rodrigues