Months between 2 dates

[nehapathak]

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

[arulsettu]

maybe this

'month(Report date)-month(Hire date)

[nehapathak]

I have tried this but it doesn't return the correct value if the year is different

[martinpohl · Accepted solution]

=(year(today())-year(hiredate))*12                              // number of years * 12

+( num(month(today()))-num(month(hiredate)))          // + number of months

+1                                                                                // plus 1

Regards

[sunny_talwar]

You need to count people who joined between 1/1/2017 and 30/6/2017?

May be this

Count(DISTINT {<DateField = {"$(='>=' & Date(MakeDate(2017, 1, 1), 'D/M/YYYY') & '<=' & Date(MakeDate(2017, 6, 30), 'D/M/YYYY'))"}>} EmpID)