Skip to main content
N
nickk1385
February 28, 2023
Question

Displaying a date as words

  • February 28, 2023
  • 5 replies
  • 0 views

I have a date field that autopopulates a read-only field and also saves to the data. Right now in the read-only field the dates are displayed as 2/28/2023 and I would like to have it displayed as February 27 2023. any suggestions for the code? this is what I have atm 

text(local!birthDate, "mmmm") & " " & text(local!birthDate, "dd") & ", " & text(local!birthDate, "yyyy")

5 replies

abhayd3663
abhayd3663
February 28, 2023

text(today(), "mmmm dd yyyy")

O/P:

"February 28 2023"(Text)

Ref. https://docs.appian.com/suite/help/22.4/fnc_text_text.html

N
nareshs945
February 28, 2023

you can also use datetext function. datetext(today(), "MMMM dd yyyy")

    swapnar6405
    swapnar6405
    March 1, 2023

    a!localVariables(
    local!birthDate: today(),
    text(local!birthDate, "MMMM dd yyyy")
    )

    T
    thiliniu4753
    March 2, 2023

    hi, 

    i think this will help you

    C
    chiragj3013
    March 2, 2023

    you can also use datetext() function for this problem 
    Example-> datetext(today(),"MMMM dd yyyy")

    Terms & ConditionsAccessibility statement