Skip to main content
S
satheeshkannank0001
April 1, 2024
Solved

Appian Date to text conversion

  • April 1, 2024
  • 7 replies
  • 1 view

Appian month to text conversion  issue 
I am using this command 
month(today()) ---> it print current month 

after this i am plan to convert this as a text format  like 

text(month(today()),"MMM")  my output is something different 

let me know the cause of this 

    Best answer by venkatrea696188

    Can you tell what you are expecting as output? ,It's not gonna give "Apr" because you are passing integer value as a parameter instead of date time .

    text(today(),"MMM")

    Go with this

    7 replies

    karumurua531442
    karumurua531442
    April 1, 2024

    hi[mention:d6404087295d4abeb397e2328c8ee61c:e9ed411860ed4f2ba0265705b8793d05] may i know your expected output

    venkatrea696188
    venkatrea696188Answer
    April 1, 2024

    Can you tell what you are expecting as output? ,It's not gonna give "Apr" because you are passing integer value as a parameter instead of date time .

    text(today(),"MMM")

    Go with this

      D
      daisym144875
      April 1, 2024

      Hi [mention:d6404087295d4abeb397e2328c8ee61c:e9ed411860ed4f2ba0265705b8793d05] ,

      https://docs.appian.com/suite/help/24.1/fnc_text_text.html

      Please Visit this It Will Help in Perfect Manner .

        K
        karimireds772782
        April 1, 2024

        text(today(),"dd-mmm-yyyy") You can use this the Output is 01-Apr-2024

          stefanhelzle0001
          stefanhelzle0001
          Brainy
          April 1, 2024

          month() returns an integer. Then, text() does not treat it as a date and does not understand how to interpret your formatting string.

          Use this instead: text(today(), "MMM")

            shubhama926776
            shubhama926776
            Brainy
            April 1, 2024

            [mention:d6404087295d4abeb397e2328c8ee61c:e9ed411860ed4f2ba0265705b8793d05]  Can you please tell us what do you want as a output?
            If you want to print month i would suggest you to use  text(today(), "MMM")

            शुभम्
              S
              sriharin8305
              April 2, 2024

              Hi [mention:d6404087295d4abeb397e2328c8ee61c:e9ed411860ed4f2ba0265705b8793d05] ,

              I hope you are expecting output as below. if not tell me what the output was you are expecting.

              Thanks

                Terms & ConditionsAccessibility statement