[XML Records] Date Time Format

Forge Component
(44)
Published on 2019-11-25 by Afonso Carvalho
44 votes
Published on 2019-11-25 by Afonso Carvalho
Below is the XML that I will need to import to Record List.

<uid>49648838</uid><lastUpdatedUid>AAAAAE4X/X4=</lastUpdatedUid>
      <utcFirstCreated>2014-08-01T05:50:41.303</utcFirstCreated>
      <utcLastModified>2014-08-01T05:50:41.303</utcLastModified>
      <transactionType>GJ</transactionType>
      <date>2014-08-01</date>

But as you've noticed the date time field has milliseconds and I can't insert it on a OS Date Time field. Any work arounds?

Hi JC,

I would like to know if you got around this problem? And if so, how you did it.

Regards,

Daniel

My workaround was to read the XML into an intermediary structure with the datatype of Text, then convert the text to a date time with the TextToDateTime function as I put it into the DB or final structure.