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
can anyone answer for this?
your goal is a bit hard to understand. you try to call stored procedures from DB?
how can I convert months to years?
Depending on your date format, you could use a combo of TIMESTAMPDIFF, YEAR, MONTH functions in MariaDB to them subtract, etc.
© 2022 Appian. All rights reserved.