Convert a datetime Text to DateTime object

In the past I needed to do a much similar conversion - here's the expression rule I used:

with(
  local!dateTimeValueArray: split(substitute(substitute(substitute( ri!string,  " ", ":" ), "-", ":"), ".", ":"), ":"),
  if(
    rule!APN_isEmpty(local!dateTimeValueArray), 
    null(),
    datetime(
      local!dateTimeValueArray[1],
      local!dateTimeValueArray[2],
      local!dateTimeValueArray[3],
      index(local!dateTimeValueArray, 4, 0),
      index(local!dateTimeValueArray, 5, 0),
      index(local!dateTimeValueArray, 6, 0),
      index(local!dateTimeValueArray, 7, 0)
    )
  )
)

In the past I needed to do a much similar conversion - here's the expression rule I used:

with(
  local!dateTimeValueArray: split(substitute(substitute(substitute( ri!string,  " ", ":" ), "-", ":"), ".", ":"), ":"),
  if(
    rule!APN_isEmpty(local!dateTimeValueArray), 
    null(),
    datetime(
      local!dateTimeValueArray[1],
      local!dateTimeValueArray[2],
      local!dateTimeValueArray[3],
      index(local!dateTimeValueArray, 4, 0),
      index(local!dateTimeValueArray, 5, 0),
      index(local!dateTimeValueArray, 6, 0),
      index(local!dateTimeValueArray, 7, 0)
    )
  )
)

Thanks Mike.

Hi Sunil,
I just want to know what is your requirement. Are you using any service to get data from DB. I see that the Date Time text format is in converted Json format. if you are getting this type of format from service. In my perspective better to get the proper date time format from service so that we can reduce the calling the custom rule for Converting the date time text to Date time object for each of the date & time parameter

Great solution and smart work!