4 Replies Latest reply: Aug 13, 2015 1:56 PM by neetha P RSS

    Calculate number of months between dates in script

    Jeff Robertz

      Hi there,

       

      Anyone can help me compute the number of months between two dates in the script.

      It seems quite obvious but I can't manage to make this work so would appreciate your guidance.

      Below an example of what I try to achieve:

      - Start Date and End date are part of the original file

      - NumberOfMonth is what I try to compute.

       

      Many thanks for your helps!

       

      Start DateEnd DateNumberOfMonth
      01/01/201631/12/201612
      01/01/201631/07/20167
      01/01/201615/08/20168
      01/01/201628/02/201714