Date

How I can I convert number of months into year?

  Discussion posts and replies are publicly visible

Parents Reply
  • okay sure.  yes I have sp rule which is taking inputs as integer values and giving me output as a integer. so now i am trying to convert those days(6 or 12 or 24 etc) into months and add to date(date may be dd/mm/yy) my code is below

    /* this is sp rule*/
    a!localVariables(
    
      local!spResult: fn!executestoredprocedure(
        dataSourceName: cons!DATASOURCE_NAME,
        procedureName: cons!SP_MONTHS,
        inputs: {
          {
            name: "CI",
            value: ri!ci_int,
            
          },
          {
            name: "CODE",
            value: Code_int,
           
          }
        }
      ),
      
      if(
        
        and(
          local!spResult.success,
          not(
            isnull(
              local!spResult.parameters
            )
          )
        ),
        local!spResult.parameters.MONTHS,
        ""
      )
        
        
      )
     

Children