Calculate the years and months from two given dates
1
I want to calcuate the years and months in decimal from two dates given, for example i have 02-31-2019 earlier date and current date 02-07-2022 , how i calculate the difference? i want the answer 2.6 means 2 years and 6 months. how i calculate this?
asked
Neenu Viswam
1 answers
3
Hi Neenu,
You can use the Java action “MonthsBetween” from the community commons (MarketPlace Module ) and then divide the outcome by 12 and floor it for the number of years and use the function “mod” 12 for the remaining months.