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
1 Like