Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check Rob's response here:
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
Try this
SET MonthDiff = ((2016*12)+1) - ((2013*12)+1);
Thanks a lot sunny it worked !