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
Comments
Please sign in to leave a comment.