Skip to main content
New Participant
Apr 1, 2024 9:27 AM UTC
Solved

Appian Date to text conversion

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 

    venkatrea696188
    Inspiring
    Apr 1, 2024 9:30 AM UTC

    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
    Participating Frequently
    Apr 1, 2024 9:30 AM UTC

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

    venkatrea696188
    Inspiring
    Apr 1, 2024 9:30 AM UTC

    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

    Participating Frequently
    Apr 1, 2024 9:48 AM UTC

    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 .

    Participating Frequently
    Apr 1, 2024 10:01 AM UTC

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

    stefanhelzle0001
    Brainy
    Apr 1, 2024 10:46 AM UTC

    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
    Brainy
    Apr 1, 2024 11:19 AM UTC

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

    शुभम्
    New Participant
    Apr 2, 2024 11:59 AM UTC

    Hi [mention:d6404087295d4abeb397e2328c8ee61c:e9ed411860ed4f2ba0265705b8793d05] ,

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

    Thanks