Stored Procedure(SP)

Hello all,

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

Parents
  • 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?

Reply
  • 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?

Children
No Data