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.

harshitham3563 · 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])
  )
)

mikes0011 · 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.

Sign up

Login with SSO

Login to the community

Login with SSO