Skip to main content
September 9, 2025
Question

September is Abbreviated to Sept even though Left() function is used

  • September 9, 2025
  • 13 replies
  • 0 views

if(
rule!APN_isBlank(singlePV: ri!date),
"",
/*left(text(ri!date, "mmm",3), ri!format))*/
left(text(ri!date,"mmm",3), ri!format)
)

Following is the error 

Expression evaluation error at function 'text' [line 7]: Signature length (2) does not match parameter length (3)

    13 replies

    harshas2775
    September 9, 2025

    When inserting code using this is recommended Insert->Code

     

    harshas2775
    September 9, 2025

    if(
      rule!APN_isBlank(singlePV: ri!date),
      "",
      /*left(text(ri!date, "mmm",3), ri!format))*/
      left(text(ri!date,"mmm"), 3) 
    )

    text() needs two parameters (value, format), left() needs two parameters (text, num of chars). Your text() has 3 parameters which might be causing this. Try and work with the above code to resolve the issue. 

    shubhama926776
    September 9, 2025

    Remove the 3 from the text() function. The text() function only needs:
    The date value (ri!date)
    The format string ("mmm")

    if(
     rule!APN_isBlank(singlePV: ri!date),
      "",
      left(text(ri!date, "mmm"), ri!format)
    )


    The left() function with ri!format will handle truncating the month name to the desired length.

    September 10, 2025

    This is still not working. As the left function needs the number of characters to be extracted from the text which is still missing from the code. It is not giving any result.

    shubhama926776
    September 10, 2025

    May i know what input and output you are expecting to help you better?