2021-11-09T12:05:19 UTC into dd/mm/yyyy Importomatic VBA

[vbanewbie68]

Hi Sir or Madam
Please see the screenshot above I am using an importomatic VBA for Raisers Edge. I get an exception report to say the date is invalid. I am trying to tell VBA to change this 2021-11-09T12:05:19 UTC to dd/mm/yyyy format.

See the below the 2nd screenshot: the first line section is incoming data and the 2nd section is computed data. The circle highlight should show real date format instead of letter dd/mm/yyyy.

I believe there is something wrong with the code line:

import.Fields.GetByName("last_modified_at").value = Format(Split(import.Fields.GetByName("last_modified_at").Value,"T")(0),"dd/mm/yyyy")

I hope everything is clear?

Thank you

Best regards

V