Hi, I have a concern about the text() function after Appian Upgrade 23.4.
The code: text( gmt(todatetime("01/09/2023"), timezone()) + intervalds(12,00,00), "dd-mmm-yy hh:mm:ss") & " AM'"
The output: "01-Sept-23 12:00:00 AM'"
The output keeps returning "Sept" instead of "Sep" and this is only happening for the month of September. The other months are returning the first 3 letters.
Does anyone know how to resolve this?
Discussion posts and replies are publicly visible
In my case with 23.4 , the code is working as expected.
May I know hotfix version of 23.4 you have used?
And also May I know the locale you are using in the admin console Internationalisation setting?
We are facing the issue with 23.4.265.0 and English(UK) [en-GB] locale.
You can use this
I would assume this might have to do with your locale.
However you could ensure that the date will always have 3 characters by doing something like this:
a!localVariables( local!date: gmt(todatetime("09/01/2023"), timezone()) + intervalds(12, 00, 00), local!month: left(text(local!date, "mmmm"), 3), concat( text(local!date, "dd"), "-", local!month, "-", text(local!date, "yy hh:mm:ss"), ) )