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

Question

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)

Harsha Sharma · Answer

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.

Shubham Aware · Answer

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.