Difference b/w two dates in months

[Anonymous]

hello Guys,

I need to calculate difference between two dates and the results should be in months .

For ex:-

end date 01/01/2016

start date 01/01/2013

Results should be in months

Kindly help me with script .

Thanks,

ravi

[sunny_talwar]

check Rob's response here:

How Do I Get the Number of Months Between Two Dates?

[Anonymous]

thanks sunny for the link

I referred his link and i am trying but I am not getting result

SET MonthDiff=((year(2016)*12)+month(01)) - (((year(2013)*12)+month(01)));

Can u c whats wrong here plz.

Thanks,

ravi

[sunny_talwar · Accepted solution]

Try this

SET MonthDiff = ((2016*12)+1) - ((2013*12)+1);

[Anonymous]

Thanks a lot sunny it worked !