Is there is any prebuilt function in Appian to Convert date format in plain text "APR 1, 2021" to "YYYY-MM-DD" or can we write a custom function to achieve this ?
Discussion posts and replies are publicly visible
If you're trying to convert a plaintext date like "APR 1, 2021" into an Appian "Date" type object, you'll probably need to concoct something yourself (though if you spend a few minutes searching old posts here you'll probably find code pre-written for you). To convert a Date object to "yyyy-mm-dd" format, you can simply use the "text()" function, like "text(local!date, "yyyy-mm-dd")".