4 Replies Latest reply: Aug 1, 2017 7:37 AM by Sunny Talwar RSS

    Months between 2 dates

    Neha Pathak

      I have 2 date fields "Hire date" and "Report date"

      I want to calculate the number of employees who have joined in last six months from the report date.

       

      How do we calculate the months b/w 2 dates.

       

      for eg-

      Report date is 30/6/2017 and hire date is 30/12/2016 it should give me 6 as answer