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