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

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)
)

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.

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

I am expecting incoming date in the format "09/09/2025" and output should be in dd-mmm-yyyy. For rest of the months the existing code is working fine. However, returning September as Sept.

Input - "09/09/2025"

Output - 09-Sep-2025

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"
)

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  Not working still 

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")
)

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"
    )
  )
)

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"
    )
  )
)

Shubham Aware Somehow we have encountered this issue for July too earlier but in 2025, facing issue with September. I am sure Appian should have some resolution going forward to fix it from root.

I will try the recommendations you have shared. Thanks for keeping an eye on this.