Convert date format in plain text "APR 1, 2021" to "YYYY-MM-DD" ?

Question

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 ?

Mike Schmitt · Answer

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

Convert date format in plain text "APR 1, 2021" to "YYYY-MM-DD" ?

Top Replies