How I can I convert number of months into year?
Discussion posts and replies are publicly visible
Divide by 12?
You need to give us more to go on. For this it would be good to have expected inputs and outputs. Is this what you're after?
Input 12 --> Output 1
Input 36 --> Output 3
Input 18 --> Output 1.5
Input 25 --> Output 2.08
label: "Enter month",
label: "Year (s)",
quotient(local!months,12) & " year and " & mod(local!months,12) & " month",
Please try this code
this is fine ,but now I have the sp rule in which it is returning no of months fox ex: 6 months. i need to use this 6 or 12 or 24 months with the date and convert into months , how will i do that?
I'm still struggling to understand what you need. Does the stored procedure ONLY return 6 months? Does it return 6 months and a date and you want to add the 6 months to the date and end up with another date? We have no idea what you need.
© 2022 Appian. All rights reserved.