Skip to main content
R
reneet0001
January 2, 2024
Question

text() function after Appian Upgrade 23.4

  • January 2, 2024
  • 5 replies
  • 0 views

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

/resized-image/__size/640x480/__key/communityserver-discussions-components-files/11/Screenshot-2024_2D00_01_2D00_02-at-6.08.20_2F20_PM.png

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? 

5 replies

V
vijendram6281
January 2, 2024

davidj137213
davidj137213
Brainy
January 2, 2024

In my case with 23.4 , the code is working as expected.

S
snehay0001
January 3, 2024

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.

 

V
vijendram6281
January 3, 2024

You can use this 

mathieud0001
mathieud0001
Brainy
January 3, 2024

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

Terms & ConditionsAccessibility statement