Text to date conversion

Question

How do I convert the "Thu, 10 Nov, 2022" this text to date? 
 I am getting this data from IDP in text format.

Harshitha Mangamuri · Accepted Answer

Hi Vijay Kumar, Please look at this code. Hope it will be helpful if the input is in the mentioned format as above. 
 a!localVariables(
 local!months: {
 "Jan",
 "Feb",
 "Mar",
 "APR",
 "May",
 "Jun",
 "Jul",
 "Aug",
 "Sep",
 "Oct",
 "Nov",
 "Dec"
 },
 local!splitString: ldrop(
 a!forEach(
 items: split(ri!input, " "),
 expression: substitute(fv!item, ",", "")
 ),
 1
 ),
 date(
 tointeger(local!splitString[3]),
 wherecontains(local!splitString[2], local!months),
 tointeger(local!splitString[1])
 )
)

Mike Schmitt · Answer

Off the top of my head I'd guess you will need to build your own Expression Rule to parse the specified text date format you need to consume into a standard Appian Date type object. If you do some searching in past posts here, i'm guessing you'll find examples that others have built.