I need to calculate difference between two dates and the results should be in months .
end date 01/01/2016
start date 01/01/2013
Results should be in months
Kindly help me with script .
check Rob's response here:
How Do I Get the Number of Months Between Two Dates?
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.
SET MonthDiff = ((2016*12)+1) - ((2013*12)+1);
Thanks a lot sunny it worked !
Retrieving data ...