Hi Friends,
Logically how to change the date field mm/dd/yyyy to dd/mm/yyyy. Tried many way but to me not getting correct answer. Please share your ideas.
Discussion posts and replies are publicly visible
Appian defaults the data format to the User Locale that you have chosen fort yourself. If you enable UK English as a language within the system and then navigate to the 'Settings' option under your User Profile you can choose which language you want to use, and this controls the date format.
Thanks Stewart.. Its working
Stewart Burchell - Many thanks for your time. Just one more. If we need to format the date filed display value as "dd/mmm/yyyy" (08/dec/2021) - can you please shed some light on the same .
P.S: I'm aware that datetext will do the formatting but our requirement is that to display the "dd/mmm/yyyy" (08/dec/2021) as in date filed itself.
Just a little bit more clarity would be helpful. Do you mean how to present a previously captured data value in, say, a read-only user interface? You can use the text() function to format a date value such that is is rendered in the way you describe:
fn!text(ri!myDate,"dd/mmm/yyyy")
You have no such control over the date input/picker field.
Thanks for your swift response. Just to double confirm that the date input/picker field values cannot be altered by any means. i.e.) below image representation is not possible if my understanding is correct.
Correct. You cannot alter this components behaviour. I'm not sure why you want to do so. You either pick a date from the grid below this field, or you type in a date value. What would you expect someone to type into this field if the expected format was dd/mmm/yyyy?
Thanks for your quick reply.