How can I get the number of months between two dates?
For example, the number of months between 20/12/2010 and 20/12/2011 is 12.
Thanks for your help.
Discussion posts and replies are publicly visible
load( local!years: year( ri!todate ) - year( ri!fromDate ), local!months: ( local!years ) * 12 + month( ri!todate ) - month( ri!fromdate ), local!months)
thanks dude! this actually works. for my case I wrapped around the absolute value function to so i dont get negatives...
abs() function