What date formats does the data loader support?

Question

What date formats does the data loader support?

Answer

Following are the supported Time and Timestamp formats:

  • YYYY-MM-dd'T'HH:mm:ss.SSSZ
  • yyyy-MM-dd'T'HH:mm:ssZZ
  • yyyy-MM-dd'T'HH:mm:ss.SSSZZ
  • MM/dd/YYYY HH.mm
  • MM.dd.YYYY HH.mm
  • MM-dd-YYYY HH.mm

Following are the supported Date formats:

  • yyyy-MM-dd
  • MM/dd/YYYY
  • MM.dd.YYYY
  • MM-dd-YYYY
  • YYYY/MM/dd
  • YYYY-MM-dd
  • YYYY.MM.dd
  • YYYYMMdd

You can modify the date format in Excel by Formatting the cell using a Custom Format:

References

https://docs.reltio.com/infoandconfig/simpleattrs.html?hl=date%2Cformat

https://reltio.zendesk.com/agent/tickets/106151

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.