How to count total no of month between two dates

Question

I have a query to find out month between two dates ie between max(date) and min(date) Mobile no can repeate suppose 2011-jan-01 to 2016-01-31 the mobile no '9999111123' occur 9 times '9999211123' occur 6 times then find out months difference select distinct mobilemax(apptdate)min(apptdate)count(mobile) as [count] from crm_leadtable group by mobile having count(mobile) >7 order by count desc

Manas Mohapatra · Answer

Try like below: select distinct mobile DateDiff(month max(apptdate) min(apptdate)) count(mobile) as [count] from crm_leadtable group by mobile having count(mobile) >7 order by count desc

Ronak Patel · Answer

Just Follow DECLARE @Fromdate DATE DECLARE @Todate DATE SET @Fromdate = CONVERT(DATE'2015-09-14') SET @Todate = CONVERT(DATE'2016-10-14') SELECT DISTINCT DATEDIFF(MONTHMAX(@Fromdate)MIN(@Todate))