topic Re: Difference b/w two dates in months in App Development

Difference b/w two dates in months

Anonymous — Thu, 04 Jan 2018 15:29:00 GMT

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 — Thu, 04 Jan 2018 15:29:43 GMT

check Rob's response here:

Anonymous — Thu, 04 Jan 2018 16:18:23 GMT

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 — Thu, 04 Jan 2018 16:27:54 GMT

Try this

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

Anonymous — Thu, 04 Jan 2018 16:37:42 GMT

Thanks a lot sunny it worked !