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
Discussion posts and replies are publicly visible
hisatheeshkannank0001 may i know your expected output
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
Hi satheeshkannank0001 ,
https://docs.appian.com/suite/help/24.1/fnc_text_text.html
Please Visit this It Will Help in Perfect Manner .
text(today(),"dd-mmm-yyyy") You can use this the Output is 01-Apr-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")
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")
I hope you are expecting output as below. if not tell me what the output was you are expecting.
Thanks