How do I convert the "Thu, 10 Nov, 2022" this text to date?
I am getting this data from IDP in text format.
Discussion posts and replies are publicly visible
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.
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]) ) )
Thank you so much!!!Where do I learn this?
My main suggestion for learning stuff like this is to experiment with Appian expression functions and try new things for yourself.