vbanewbie68
Board Regular
- Joined
- Oct 16, 2021
- Messages
- 171
- Office Version
- 365
- Platform
- Windows
- MacOS
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