I see this recipe for calculating the number of days between two months...
How would I get the same thing but number of months instead?
It depends on what is your definition of months.
You can refer to this recipe https://www.workato.com/recipes/944768-calculate-number-of-days-between-two-dates
Steps 4-7 are examples of calculations of number of months.
The last step gives you the number of months and days.
Kevin, do you have a current link to a recipe that shows these examples? The link in the previous post is now broken.
This formula works for me, to calculate the number of "months or part thereof":
([end date pill].month - [start date pill].month) + 12 * ([end date pill].year - [start date pill].year)
Where [end date pill] is the pill of the end (later) date, and [start date pill] is the pill of the start (earlier) date.
Send us a ticket, we will try our best to assist you with your problem