For example... I have 2 date fields "renewal policy starts" and "renewal policy ends"
If the dates are 7/1/11 and 6/31/12.. how would I end up with a 12 ?
If I simply use the month function, I get a -1 ... ?
Any help would be greatly appreciated!!!
Thanks!!
8 answers
Please try this and let me know if doesn't work for you : TEXT((YEAR( End_Date__c )*12+MONTH(End_Date__c ))-
(YEAR( Start_Date__c )*12+MONTH(Start_Date__c )))
--Regards
Ankit Arora | Certified Developer
_img src="http://1.bp.blogspot.com/-6or5Qdjdlpc/TfWeKZIQ9fI/AAAAAAAAADY/QJOxPzAaUt0/s170/Ankit-FB.png" /_ _img src="http://3.bp.blogspot.com/-_zrHcu18xjM/TfWeOWM2vAI/AAAAAAAAADg/IwJ3z3NEbEg/s170/blogger_logo50.jpg" /_ _img src="http://1.bp.blogspot.com/-ycM-M1F5peQ/TfWfPIx9dTI/AAAAAAAAAEA/5vmr179iJQA/s170/linkedin_logo.png" /_ _img src="http://1.bp.blogspot.com/-OZJJ4xf2KII/TfWedGqxZpI/AAAAAAAAAD4/26hAR7HTd8o/s170/twitter-logo.png" /_ _img src="http://3.bp.blogspot.com/-I9YdeYGmhIQ/TfWgJKbnDAI/AAAAAAAAAEU/DbTt-vKOjuQ/s170/bug_blue_normal.png" /_
