Apex Code Development You need to sign in to do that
Don't have an account?
Lori_ Calculate number of months between dates
We have a formula that assumes all policies are 12 months. Now, we have some policies are 3 months.
Since we have the policy begin dates and policy end dates, I tried "End date - Begin date". It gives me the results in days but they want it in number of months.
Any suggestions?
There's so much that can be considered when calculating time between dates. A long very complex formula coupled with some validation rules could bring absolute perfection to this calculation, but that may not be necessary for your use-case.
I'd first try this simple approach:
ROUND((End date - Begin date)/30,0)
Although the calculation isn't precise, the rounding should produce the right number of months as long as your begin and end dates are truly 3 or 12 months apart as you indicate.