Loading

How to count total no of month between two dates

Vandana

10y887SQL

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 mobile,max(apptdate),min(apptdate),count(mobile) as [count]
from crm_leadtable
group by mobile
having count(mobile) >7
order by count desc

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Accepted 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
10y ago
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(MONTH,MAX(@Fromdate),MIN(@Todate))