Appian Date to text conversion

Question

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

venkat Avuluri · Accepted Answer

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

DaisyManmohanSingh · Answer

Hi satheeshkannank0001 , 
 https://docs.appian.com/suite/help/24.1/fnc_text_text.html 
 Please Visit this It Will Help in Perfect Manner .

Srihari Karimireddy · Answer

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

Stefan Helzle · Answer

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

Shubham Aware · Answer

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

Srihari Nuthangi · Answer

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

Appian Date to text conversion

Top Replies