I have the rule ,in which once one date valuation enters ,next date value is coming in terms of years with the rule based on some condition from the database. Now I need to get those dates columns in terms of months using stored procedure has created for that. How can I achieve with the sp?
ri!date+(ri!numberOfYears * 365)- rule for the no of years
Discussion posts and replies are publicly visible
Why does it need to be a stored procedure that does this? I'm finding it hard to decipher what you are trying to achieve but is it that you have two dateTimes that are exactly X years apart and you need to convert this difference into the number of months?
© 2022 Appian. All rights reserved.