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.

Shubham Aware · Answer

Could you try this once Let me know if that works for you. text(
 index(todate("09/09/2025", "MM/dd/yyyy"), 1),
 "dd-MMM-yyyy"
)

Harsha Sharma · Answer

You can simply use text to get the desired output, why make it complex with left(). For every date this will work for you by passing the expected output format in text(). 
 text(ri!date,"dd-mmm-yyyy")

Harsha Sharma · Answer

Can you check if under Settings->General you have locale set as English(United Kingdom). Looks like the Internationalisations settings are at play here causing this behaviour. I have it as United States and it returns output as 'Sep' 
 
 If for reasons, you cannot update the Locale to US then you can try and handle the September month like below. Give it a try! 
 if(
 month(ri!date) = 9,
 substitute(
 text(ri!date, "dd-mm-yyyy"),
 "-09-",
 "-Sep-"
 ),
 text(ri!date, "dd-mmm-yyyy")
)

Shubham Aware · Answer

Got you! This issue is because of user locale. User Level: Change user profile locale from en_GB (UK) to en_US (US) => affects only that user Admin Level: Go to Admin Console -> Internationalization -> Change Primary Locale to en_US => applies to all users in the environment. This locale problem is only for September month recommend you to make changes to code instead of environment level. Below working example for all months a!localVariables(
 local!date:"09/11/2025",
 local!formattedDate: text(local!date, "dd-MMM-yyyy"),
 if(
 isnull(local!date),
 null,
 substitute(
 local!formattedDate,
 "Sept",
 "Sep"
 )
 )
)