I want to data import a datetime that is formatted yyyy-MM-ddTHH:mm:ss which I think means I have to use the Custom Option in data imports. However I can’t figure out how to get the T to be recognized and keep getting an error. Does anyone know how to do this?
For DateTimes, Dates, and Times, Java’s DateTimeFormatter is used for parsing. In that documentation, the Patterns for Formatting and Parsing section gives thorough examples and rules for the patterns that can be applied in the Mapping Options field of Data Import Definitions.
For your specific question, it looks like you need to surround the T in quotes for it to be treated as a string literal: yyyy-MM-dd'T'HH:mm:ss
Interesting info on these formats.
I do not see Julian dates here. I have a situation to import from JDE and some dates there are marked as Julian Date
What should be the approach to import these?
OK, I got it in the Mapping Formats…
Mapping Sub Type
If your data looks like this (which it may when exporting from Nextworld for certain system datetime fields like nwCreatedDate): 2026-04-13T12:15:02.439757Z
Use this Mapping Option: “yyyy-MM-dd’T’HH:mm:ss.SSSSSSX” (with encapsulating double quotes)
If you datetime field looks like this (common for all other datetime fields exported from NW): 2026-03-09T13:30:19.184Z
Use this Mapping Option: “yyyy-MM-dd’T’HH:mm:ss.SSSX” (with encapsulating double quotes)
One thing we found today is to parse datetimes, the format will need to be encapsulated in "". So for example, to parse an input of 2026-02-25T15:21:44.092688Z the Custom Options should be configured as "yyyy-MM-dd'T'HH:mm:ss.SSSSSSXX"