1 Reply Latest reply on Sep 3, 2018 8:31 AM by Nitin Paighowal

    month count

    Imran Azam



      i am trying to work out the length of contract by month , I have a start date: 27/09/2016 and end date : 26/06/2017, i have done a calculation field below to count the lenth of contact


      IF DATEDIFF('month',[Start Date],[End Date]) < 1 THEN 1

      ELSE DATEDIFF('month', [Start Date], DATEADD('day', 15, [End Date])) END


      fo the above dates i am getting 10 but i need this to be 9 as it is 9 months


      can anyone help me fix this?


      thank you