[XML Records] Date Time Format

Juan Carlos Elorde

Question

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?

01 Aug 2014

Daniël Kuhlmann

MVP

Hi JC,

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

Regards,

Daniel

22 May 2018

Kevin Werner

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.

17 Feb 2020

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines